Home > SharePoint 2010, SharePoint Administration > SharePoint 2010 – Database is up to date, but some sites are not completely upgraded

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

I was updating my current SharePoint 2010 farm with the latest and greatest SharePoint Server 2010 SP1 update and after applying the update and attempting to run the SharePoint 2010 Products Configurations Wizard to complete the installation the wizard was failing on Step 9 of the process.  After trying to run the wizard again I was able to successfully complete the wizard with no errors.

However, as I was looking at Central Administration I noticed the SharePoint Health Analyzer was detecting some errors.  Checking the issues I noticed that their were errors in Configuration, so I clicked on the Update and Migration link to the left and clicked on the Review database status link under Upgrade and Patch Management.

I noticed that the Content Database status was set to ‘Database is up to date, but some sites are not completely upgraded’

That told me that even though the SP1 applied  the database was not completely upgraded.

If you ever run into this message or problem, this is what I did to fix the issue.

1.  Log into your Central Administration Server
2.  Bring up SharePoint 2010 Management Shell (PowerShell)
3.  Type Get-SPContentDatabase -Identity [name of database]
4.  This will list the GUID (ID) of the database that needs to be upgraded.
5.  Right click inside PowerShell select Mark
6.  Highlight the database GUID (ID) and right click (this will save the ID in the clipboard)
7.  Next type
upgrade-spcontentdatabase -id [GUID] (right click and paste the ID you copied from Step 6)
8.  Hit Enter
9.  You will then be prompted to confirm:

Are you sure you want to perform this action?
Performing operation “Upgrade-SPContentDatabase” on Target Database GUID
[Y] Yes [A]Yes to All [N] No [L] No to All [S] Suspend [?] Help
<default is “Y”>:

Type: Y at this stage and hit enter.

10.  You will see the progress of completion percentage increase.
11.  Once it reaches 100% its complete and you can now close out of PowerShell.
12.  Go back to Central Administration -> Manage Database Update Status and refresh the page.
13.  You should now see the database status set to No Action required.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: