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:
- 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