locked
MOSS 2007 database on sqlserver 2005 to SP2010 with SQLServer 2008 R2 problem RRS feed

  • Question

  • Dear all, i am in a middle of content database migration of moss 2007 built on SQLServer 2005 to SharePoint 2010 with SQLServer 2008 R2. What I did? 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 getting the following error. Sequence [Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence] cannot upgrade an object [SPContentDatabase Name=WSS_Content] whose build version [12.0.0.6219] is too old. Upgrade requires [12.0.0.6421] or higher. How to solve this issue please help. 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.
    Friday, June 10, 2011 12:15 PM

Answers

  • Hi,

     

    In order to upgrade the SharePoint 2007 to SharePoint 2010, we must update SharePoint 2007 to Service Package(SP) 2 at least. The requirement is mentioned in this article:

     

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

    “Office SharePoint Server 2007 must be updated to Service Pack 2”

     

    What’s more, you have chosen the database attach upgrade method, please refer to the following article to check if your steps are correct:

     

    Attach databases and upgrade to SharePoint Server 2010

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

     

    Thanks,

    Rock Wang


    Regards, Rock Wang Microsoft Online Community Support
    Monday, June 13, 2011 7:01 AM