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.

Database is up to date, but some sites are not completely upgraded

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
}

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

6 thoughts on “Database is up to date, but some sites are not completely upgraded – Fix

  • It does not seem to go away. Do i have to run the configuration wizard on all SharePoint servers?

    Reply
  • 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

    Reply
  • The last command under Fix database upgrade status should have $DatabaseID not $DB

    #Update Content Database
    Upgrade-SPContentDatabase -id $DatabaseID -Confirm:$false

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *