Resume Content DB upgrade

I’m going to start this post with a couple of little issues when upgrading your SharePoint environment, but there are several great references for you


If your SharePoint 2010 upgrade is stuck and you get the following in Central Administration “database is up to date, but some sites are not completely upgraded”. Note, there is a whole lot of misinformation out there about performing/reinitializing an upgrade by using the psconfig -cmd upgrade -inplace v2v (or b2b) commands. However, this is for upgrading your Farm and if it is failing on the content databases, it will continue to fail. The below is all about resuming the content database upgrade.
 The first thing you will need to do is get the Site ID for the Database that is problematic

Get-SPContentDatabase -Identity Name_of_Database

 That should return something that looks like this…



Once you have the ID, you’ll want to execute the Update-SPContentDatabase command

upgrade-spcontentdatabase -id f7f9907c-71e8-494d-8f2b-4ce6a5b934ea

References:

• Resuming a SharePoint Database Upgrade: http://technet.microsoft.com/en-us/library/ff382638.aspx
• All about SharePoint 2010 Upgrades: http://technet.microsoft.com/en-us/library/cc303420.aspx

 http://www.shareesblog.com/?p=560