Database is up to date, but some sites are not completely upgraded – Fix
Problem: Getting database status as “Database is up to date, but some sites are not completely upgraded” from the “Review Database Status” page in Central Administration.
Root Cause: This simple means: The SharePoint Products Configuration wizard is unsuccessful in upgrading the specific database.
Solution:
- Go to SharePoint Central Administration >> Upgrade and Migration >> Review database status >> Get the list of Databases that need upgrade.
- Fix database upgrade status with below PowerShell cmdlet: Upgrade-SPContentDatabase
Fix database upgrade status with PowerShell cmdlet: Upgrade-SPContentDatabase
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Set this variable value accordingly
$DatabaseName = "content_database_name_here"
#Get the Database ID
$DatabaseID = (Get-SPContentDatabase -identity $DatabaseName).ID
#Update Content Database
Upgrade-SPContentDatabase -id $DatabaseID -Confirm:$false
Once the process completes, Go back to the “Manage Databases Upgrade Status” page in Central Admin and check the status, It should be “No action required.”
Upgrade All content Databases:
Rather than doing it one by one, let’s upgrade all content databases in a single stretch.
$WebAppURL= "https://intranet.crescent.com"
#Get all content databases of the particular web application
$ContentDBColl = (Get-SPWebApplication -Identity $WebAppURL).ContentDatabases
foreach ($contentDB in $ContentDBColl)
{
#Updade each content database
Upgrade-SPContentDatabase -id $contentDB.Id -Confirm:$false
}
It does not seem to go away. Do i have to run the configuration wizard on all SharePoint servers?
Did you upgrade all content databases of all web apps?
Thank you, it fixed the problem in my farm. A suggestion, PowerShell can be written more concisely; it is not VB 🙂
# one database by name
Get-SPContentDatabase “content_database_name_here” | Upgrade-SPContentDatabase -Confirm:$False
# All databases for a web app
Get-SPContentDatabase -WebApplication “https://intranet.crescent.com” | Upgrade-SPContentDatabase -Confirm:$False
# All databases for all web apps
Get-SPContentDatabase | Upgrade-SPContentDatabase -Confirm:$False
Agreed! Thanks, But its written in such way for better readability.
The last command under Fix database upgrade status should have $DatabaseID not $DB
#Update Content Database
Upgrade-SPContentDatabase -id $DatabaseID -Confirm:$false
Fixed the Typo! Thanks!!