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, You have installed the latest patch/service pack, and running SharePoint products configuration wizard is pending still! 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 BDC service application, just execute below cmdlet in the PowerShell console.

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

Once its 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

  • September 1, 2021 at 10:03 PM

    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
    • September 8, 2021 at 9:55 PM

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

      Reply

Leave a Reply