Overcome Test-SPContentDatabase “Database too old error message”

Ok, I was thinking that I could quickly take a SharePoint 2007 content database, apply the minimum Service Pack 2 for WSS 3.0 and MOSS 2007, and then perform a database attachment within SharePoint 2010 in minutes while basking in the glory of the easy process.   I should have known this is SharePoint and everything is earned in this world.  🙂

I rebooted all the web front end servers and application servers just to make sure my little SharePoint 2007 world had the right build number of 12.0.0.6421 within Central Admin.   So I did a backup of the database and then moved the BAK file to the SharePoint 2010 Database instance and performed a simple restore.  For extra incentive and I was the DBO in the environment, I placed the SP Farm Account DBO to make sure the attachment goes ok.

I ran the PowerShell commandlet Test-SPContentDatabase to verify the database.  Then I got the error.

[box type=”warning”]Category: DatabaseValidation Error: True UpgradeBlocking: False Message: This database [SSPBeta] is too old and cannot be upgraded. Remedy: Upgrade this database to Windows SharePoint Services Version 3, SP2 or later. [/box]

[box type=”info”]So after I read multiple blogs, forums, etc.; I wanted to think outside-of-the-box. I tried an idea. “Maybe the commandlet needed a build number newer than 12.0.0.6421?”

So I got the April/2009 Cumulative update for WSS 3.0 and MOSS 2007. So I applied these two CU’s to the SharePoint 2007 Environment.

I verified I was on build number 12.0.0.6504. [/box]

Just like washing your hair.  Rinse and Repeat. 

So I did a backup of the database and then moved the BAK file to the SharePoint 2010 Database instance and performed a simple restore.  For extra incentive and I was the DBO in the environment, I placed the SP Farm Account DBO to make sure the attachment goes ok.

I ran the PowerShell commandlet Test-SPContentDatabase to verify the database.

 [box type=”shadow”]Then Poof!!!   The Test-SPContentDatabase command liked this minor build update.[/box] 

 Resources for review:

I welcome any feedback.

Leave a Reply

Your email address will not be published.