Upgrade:You cannot add the same content database more than once to a farm, even on different Web applications

May 7, 2008 at 8:11 pm · Filed under MOSS, SharePoint, upgrade ·Tagged contentdatabase, datbase migration, MOSS, SharePoint, upgrade, web application

Problem:

 

Number of sites are zero after upgrade using database migration technique.  

 

Resolution:

 

Each site collection in a content database (including each portal site) has a globally-unique identifier (GUID) associated with it, registered in the configuration database. So, adding the same site collection (or portal) twice to the farm, even in separate Web applications, is not possible. Although the database attach succeeds in this situation, the site collection cannot be started. If you need a duplicate copy of a site collection (or portal) in the same farm, first attach the database that contains the site collection to a separate farm, and then use the Stsadm.exe backup and restore operations to copy the site collection over to the other farm. The backup and restore process creates a new GUID for the site collection.

 

Saved my life 🙂

 

 

http://technet.microsoft.com/en-us/library/cc288476.aspx

Permalink