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



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




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 🙂






  1. ravi said

    Number of sites are zero after upgrade using database migration.Fot the first time it shows the correct amount of sites,when I tried to attach the same content batabase,it is showing the number of sites are 0.What is the best solutuion for this.I dont want to duplicate the database.

    • Farhan Faiz said

      As per MS, you cann’t attach database twice. No idea for any workaround :(.

RSS feed for comments on this post · TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: