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
If you want more IT Software Solutions
ReplyDeleteVailca Software IT Solutions
Vailca
I had this problem too before. I think the file is really too long to download. I read some articles and used Long Path Tool. I was happy because it worked.
ReplyDeleteFantastic Blog..!!
ReplyDeleteThanks for sharing such a good information
We offer SHAREPOINT ONLINE TRAINING