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 “Review Database Status” page in Central Administration,

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

Root Cause: This simple means: 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 doing it one by one, lets upgrade all content databases in a single stretch.

$WebAppURL= "http://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 is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

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

  • August 8, 2018 at 10:43 PM

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

    Reply
  • April 19, 2017 at 3:25 AM

    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 “http://intranet.crescent.com” | Upgrade-SPContentDatabase -Confirm:$False

    # All databases for all web apps
    Get-SPContentDatabase | Upgrade-SPContentDatabase -Confirm:$False

    Reply
  • March 3, 2016 at 4:27 PM

    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