Database running in compatibility range and upgrade recommended in SharePoint

To make your farm healthy , you should be aware of the critical issues that have been detected by health analyzer.

Health Analyzer Warning

In this article, I will elaborate How to solve “Database running in compatibility range and upgrade recommendedissue by following the mentioned steps below :

Steps:

  • Click on View these issues link to list all the issues that have 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 its details.

db running in compatability range details

  • In Explanation section > you can get what’s the databases that will 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 requires upgrade is “WSS_Searsch“.

The “WSS_Searsch” was appearing on non-Content Databases.therefore, the 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 SharePoint Management Shell as Administrator

  • Run  PSConfig.exe Cmdlet.

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

Run PSConfig.exe

Run PSConfig.exe succeeded

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.

Open SharePoint 2013 Configuration Wizard

Run Psconfig UI

In case of the database that requires 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 SharePoint Management Shell as Administrator

  • Run the following cmdlet to upgrade all content database that needs 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.

Review problem and solutions

  • Click on the error > From ribbon > Select the Reanalyze Now.

Reanalyze now.png

  • Go back to Health Analyzer Reports list where the error should not be now listed.

Enjoy 🙂

Advertisements

3 thoughts on “Database running in compatibility range and upgrade 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