One or more files in the restored site collection will exceed the maximum supported path length

July 27th, 2010

If you’re using the backup/restore functionality of stsadm for moving WSS3.0 site collections, you may well come across this error.

In my situation, I’m moving a site collections from

http://name

to

http://longname/sites/something

The total difference in path length between the old and new URL’s was 22. So my task was the ensure that no path lengths in my old site collection exceeded 260 (the limit) minus 22, as otherwise the new Site Collection would exceed the 260 limit once migrated.

In order to examine your WSS content Db, you’ll be wanting to run the following query in your WSS content db

SELECT
LEN(DirName + N’/’ + LeafName) AS Total,
DirName,
LeafName
FROM
Docs WITH (NOLOCK)
ORDER BY Total DESC

Then it’s usually a case of just tinkering with your longest URL’s until nothing exceeds your particular limit.


Trackback URI | Comments RSS

Leave a Reply

Name (required)

Email (required)

Website

Speak your mind