SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm about to perform a DB migration of an Intranet Publishing Site. Is it necessary to create the site collection before performing the DB restore?

share|improve this question
FYI.. I'm removing the 2007/2010 tags from your Migration questions since you have that information elsewhere in the questions and these aren't necessarily version specific. – Kit Menke Aug 8 '12 at 18:50
up vote 3 down vote accepted

To be clearer, you actually only need an Web Application to which you would attach the database. I would highly recomand before doing that go through checking/testing at least by using:

  1. Test-SPContentDatabase which will tell you if you got all other dependencies installed, etc. (
  2. Run pre-upgrade checker (see here

Also you would need at least MOSS with SP2 to be able to run these commands. There is so much documentation written on the subject. Start here

share|improve this answer
It seems preupgradecheck tool was updated with the Oct 2009 CU. So people would need to upgrade to at least that in their 2007 farm first:… – IrishChieftain Aug 14 '12 at 16:31

Yes, typically the I usually do it is, provision a web application and a site collesction then I detach the content database, copy the database accross and attach db to the site collection.

Use this to mount DB to the existing sitecollection after attaching to the new server:

Mount-SPContentDatabase "" -DatabaseServer "" -WebApplication siteUrl

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.