Database is in compatibility range and upgrade is recommended – Solution

Problem: 
After a service pack upgrade in SharePoint 2013, database status under  Central Admin >> Upgrade & Migration >> Review database status – turned into “Database is in compatibility range, and upgrade is recommended.”

Solution:

In most cases, this message simply means that you have installed the latest patch/service pack, and running SharePoint products configuration wizard is still pending! So, run the SharePoint products configuration wizard once to clear this message.

fix database is in compatibility range and upgrade is recommended

Still getting the “Database is in compatibility range and upgrade is recommended” message?
To resolve this error with the BDC service application, just execute the below cmdlet in the PowerShell console.

(Get-SPDatabase | ?{$_.type -eq "Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase"}).Provision()

Once executed, BDC database status turned to “No Action Required”.

“Database is in compatibility range and upgrade is recommended” on Content databases
In SharePoint 2016 Central Administration, under the database upgrade status page, found the status of a SharePoint content database as “Database is Running in Compatibility Range and Upgrade Recommended”.

Database is Running in Compatibility Range and Upgrade Recommended

Here is how to resolve it:

  • Run the cmdlet “Upgrade-SPContentDatabase” on the contend database once, which should resolve the problem.
    Get-SPContentDatabase -Identity <database-name> | Upgrade-SPContentDatabase
  • Run PSConfig command line: PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

2 thoughts on “Database is in compatibility range and upgrade is recommended – Solution

  • After July 2021 Updates on SharePoint 2013 server, All content, service as well as config dbs are showing “Database is in compatibility range and upgrade is recommended”. I ran the Configuration Wizard but message still persist. Any guidance much appreciated.

    Regards,
    Khushi

    Reply
    • Check if running “Upgrade-SPContentDatabase” resolves the issue on Content databases. Try Run the PSConfig on all servers.

      Reply

Leave a Reply