I have a requirement change the site collection URL (path
based). Best recommended way to change the site collection URL in sharepoint
2010 is backup and restore. I followed the same, first I took the backup and then
trying to restore the same but it giving exception.
Observation: Restoration fails if any of the URL characters
exceed the limit of 260 characters. So, please check the URL characters before proceeds
with backup and restore.
Below script will
give the accurate results of the URL characters:
Step1: connect to the DB server and then select the
content DB
Step2: Run the
script
SELECT
([DirName]+ N'/'+ [LeafName]) AS
[FullRelativePath],
LEN([DirName]+ N'/'+ [LeafName]) AS
[Length]
FROM
[dbo].[AllDocs]
ORDER BY
[Length] DESC
|
Note: If any of the URL characters exceeds the 260 characters, please make it below and then try to do the back up and restore.
-Thanks,
Sasi kumar Reddy
