In Central Administration, if you visit Upgrade and Patch Management, Review Database Status and notice some DBs have the status ‘Database is up to date, but some sites are not completely upgraded.’ follow the procedure below to rectify.
If you are attempting to upgrade the Admin Content Database then Get-SPContentDatabase will not work, or at least it didn’t for me so refer to the extra steps at the end of this article.
The upgrade status reflects the current state of the database and hence this is not resolved via PSConfig but rather by PowerShell. If you need to perform this on a production or any other important environment, make sure you have an agreed maintenance window plus backups before beginning!
- Using the farm account or equvilently privileged user, start the SharePoint 2010 Management Shell
- Enter $DB = Get-SPContentDatabase -Identity [ Your Database Name]
- Now enter Upgrade-SPContentDatabase -id $DB
- You’ll now be prompted to confirm, just hit enter to accept the default of Yes
- The upgrade will begin and a percentage complete will be displayed
When the process completes, return to Manage Databases Upgrade Status in Central Admin and the status will not be No action required.
Upgrading the Admin Content Database
As stated at the beginning of this article, Get-SPContentDatabase will not work with the Admin Content Database so another method needs to be found. As long as you know the DB GUID, you can still execute Upgrade-SPContentDatabase so a simple query of the Config database could be used to find this. However a better solution is to use Powershell.
The following script iterates though all Content DBs for a given Web Application, so can be used to upgrade the Central Admin Content Database. You will need to the replace <WA URL> in the script with your Central Administration URL.
$wa = Get-SPWebApplication -Identity "<WA URL>"
foreach($ContentDB in $wa.ContentDatabases)
{
Upgrade-SPContentDatabase -id $ContentDB
}