Saturday, May 17, 2014

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

If you get the database status as “Database is up to date, but some sites are not completely upgraded" from "Review Database Status" page in Central Administration, it simple means: SharePoint Products Configuration wizard is unsuccessful in upgrading the specific database.

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

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, 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
} 



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

2 comments :

  1. The last command under Fix database upgrade status should have $DatabaseID not $DB

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

    ReplyDelete

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...