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
([DirName]+ N'/'+ [LeafName]) AS [FullRelativePath],
LEN([DirName]+ N'/'+ [LeafName]) AS [Length]
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.
Sasi kumar Reddy