Database is in compatibility range and upgrade is recommended in SharePoint

To make your farm healthy , you should be a ware about the critical issues that has been detected by health analyzer.
health analyzer

In this article, I elaborates How to solve “Database running in compatibility range and upgrade recommended” issue by following the mentioned steps below :

  • Click on View these issues to list all the issues that has been detected by health analyzer.

db running in compatability range

  • Below Configuration category >  Click on Database running in compatibility range and upgrade recommended to view the details.

db running in compatability range details

  • In Explanation section > you can get what’s the databases that need to upgrade.

You can also check the database status through :

  • Central Administration > Upgrade & Migration > Review database status.

review database status

  • Below Status column , check the action required and it’s related database.

databse status

In this case, The database that require upgrade is “WSS_Searsch“.

The “WSS_Searsch” was appearing on non Content Databases. thereforethe database upgrade require to run  the SharePoint Configuration wizard on each server in the farm by following the mentioned steps below :

Note: It’s recommended to run the SharePoint 2013 Configuration wizard first on the main application server that host the Central administration and after it was started.Begin to run SharePoint 2013 Configuration wizard on each other SharePoint servers at the same time.where it will wait until the first wizard is finished.

To run  the SharePoint Configuration Wizard via SharePoint Management Shell :

  • Open SharePoint Management Shell as Administrator.
  • Run  PSConfig.exe Cmdlet.

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

To run  the SharePoint configuration wizard via PSConfigUI.exe

  • Log in to the main application server with the Farm account.
  • Go to Start menu > Type SharePoint Configuration Wizard.

SharePoint-2010-Products-Configuration-Wizard

Run Psconfig UI

In case of the the database that require upgrade is a Content Database you don’t need to run the SharePoint configuration wizard instead of  following the mentioned steps below :

  • Open SharePoint Management Shell as administrator.
  • Run the following cmdlet to upgrade all content database that need to be upgrade

Get-SPContentDatabase | ?{$_.NeedsUpgrade -eq $true} | Upgrade-SPContentDatabase

  • Or Run the following cmdlet to upgrade a specific content database

Get-SPContentDatabase –Identity WSS_Content_Name | Upgrade-SPContentDatabase

After the upgrade process has been done you should review database status by following the mentioned steps below :

  • Central Administration > Upgrade & Migration > Review database status.

review database status

  • Check the status columnno action required
  • All databases should now be upgraded and  no action required.
  • Go back to the Central Administration > Monitoring > Review problems and solutions.
  • Click on the error > From ribbon > Select the Reanalyze Now.
  • Go back to Health Analyzer Reports list where the error should not be now listed.

Enjoy 🙂

Advertisements

One thought on “Database is in compatibility range and upgrade is recommended in SharePoint

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