SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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 am in a middle of content database migration of MOSS 2007 built on SQLServer 2005 to SharePoint 2010 with SQLServer 2008 R2. This is what I've done.

  1. Installed SP 2010 Standard Edition
  2. Installed SQLServer 2008 R2 on another VM
  3. Created Web Application with the same content database name of moss 2007 (SQLServer 2005) for eg "WSS_Content"
  4. Went inside SQLServer and Deattached Content DB of SP2010
  5. Restored moss 2007 content database backuped from SQLServer 2005 on SQLServer 2008 R2 (name was same after restoration -> WSS_Content"
  6. applied the following command using Power Management Shell of SP2010
    stsadm -o addcontentdb -url http://testserver:90 -databasename WSS_Content

but I'm getting the following error.

Sequence [Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence] cannot upgrade an object [SPContentDatabase Name=WSS_Content] whose build version [] is too old. Upgrade requires [] or higher.

How do I solve this issue? Please note I didn't run Moss 2007 SP2 on my old intranet server...can this be a problem or I can move without it also?

share|improve this question
up vote 1 down vote accepted

SP2 is required to be installed in the 2007 environment. Steps are also provided on TechNet, Perform a database attach upgrade.

share|improve this answer
thanks for the answer pirateeric...i am in a mess at this moment and need to perform this quickly so i am worried...when i will perform the database attach will my site collection with sub sites come as it is? we didnt do any customization and everything is out of the box. – user3697 Jun 10 '11 at 15:20
Yes, everything should come over without too much trouble if it's minimally customized. You have to make sure you have the prerequisites in place first. – Eric Alexander Jun 10 '11 at 15:25
so let me compile my jobs here which i need to do now. 1. Install SP2 on my MOSS 2007 portal ........2. Backup moss 2007 (2005) content database using 2005 management studio...restore the 2005 content db with SQLServer 2008 R2 instance (sp2010) run stsadm? am i correct ? – user3697 Jun 10 '11 at 15:32
After you restore the database, you'll want to test it using the powershell test-spcontentdatabase command, then use the stsadm addcontentdatabase command or do it via powershell. The process is detailed in the TechNet article. – Eric Alexander Jun 10 '11 at 15:39
thanks i will follow it tomorrow and will update my experience here..hopefully it will go smooth :) – user3697 Jun 10 '11 at 18:11

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.