SharePoint 2010 – database is up to date, but some sites are not completely upgraded

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.

 

To resume your SharePoint 2010 Content Database upgrade. Here’s how:

 

Get the Site ID for the Database that is problematic (my database was called sl_contentDB1)

Get-SPContentDatabase -Identity sl_contentDB1

 

That should return something that looks like this…

 

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

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

 

That should get you some joy, or closer to it.

References: