Interview Questions administrator

Best SharePoint administrator Interview Questions and Answers with topic wise:


Recycle Bin | MMS | ManagedVsCrawledProperties |

Friday, April 3, 2015

Restore-SPSite problems in sharepoint

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

3 comments:

  1. 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.

    ReplyDelete
  2. Fantastic Blog..!!
    Thanks for sharing such a good information
    We offer SHAREPOINT ONLINE TRAINING

    ReplyDelete