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.

Database running in compatibility range and upgrade recommended

In this article, I will explain How to solve the below SharePoint Health Analyzer Issue

Database running in compatibility range and upgrade recommended


Steps

  • Click on “View these issues” link to list all issues that detected by SharePoint Health Analyzer.

SharePoint Health Analyzer: Database running in compatibility range, upgrade recommended

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

Health Analyzer: Database running in compatibility range, upgrade recommended

  • In “Explanation” section > Check what’re the databases that require upgrading.

Check SharePoint Database Status

You can also check the SharePoint database status by doing the following:

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

review database status in SharePoint

  • Below “Status” column, check the action required for each SharePoint Database.

Check SharePoint database status


You have now two actions based on the Type of SharePoint Database.

SharePoint Database is not Content Database

In our case, The database that requires upgrade is “WSS_Searsch“.

The “WSS_Searsch” is not a Content Databases. therefore, the database upgrade requires running the SharePoint Configuration wizard on each SharePoint server within the farm.

Note: It’s recommended to run the SharePoint Configuration wizard first on the main application server that hosts the Central Administration.

Run SharePoint Configuration Wizard Using 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 SharePoint Configuration Wizard Using PowerShell PSConfig.exe

Run PSConfig.exe cmdlet using PowerShell

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 Configuration Wizard

Run PsconfigUI.exe in SharePoint

SharePoint Database is Content Database

In case, the SharePoint database that requires upgrade is a Content Database, so you don’t need to run the SharePoint configuration wizard, and you should do the following:

  • Open SharePoint Management Shell as administrator.

Run SharePoint Management Shell as Administrator

  • Run the below cmdlet to upgrade all content database that needs to be upgraded.

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

  • Alternatively, you can run the below cmdlet to upgrade a specific Content Database.
Get-SPContentDatabase –Identity WSS_Content_Name | Upgrade-SPContentDatabase

Review SharePoint Content Database Status

After the upgrade process is done, you should review database status as the following:

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

review database status

  • Check the status column, All databases should now be upgraded and show “No action required

Review SharePoint Content Database Status - no action required

  • Go back to the Central Administration > Monitoring > Review problems and solutions.

Review problem and solutions in SharePoint Central Administration

  • Click on the error to open it.
  • From the above ribbon > Select the “Reanalyze Now“.

Reanalyze SharePoint Health Analyzer Errors

  • Go back to “Health Analyzer Reports list“, you will note that the “Database running in compatibility range and upgrade recommended” error is not listed.

Applies To
  • SharePoint 2016.
  • SharePoint 2013.
  • SharePoint 2010.
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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s