Database is in compatibility range and upgrade is recommended – Solution

Problem: 
After a service pack upgrade in SharePoint 2013, the database status under Central Admin >> Upgrade & Migration >> Review database status changed to “Database is in compatibility range, and upgrade is recommended.” The same issue was logged in the SharePoint Health analyzer.

Solution:

In most cases, this message means that you have installed the latest patch/service pack, and running the SharePoint 2016 products configuration wizard is still pending! In other words, the databases run with a backward-compatible range, earlier than the current SharePoint software. So, run the SharePoint products configuration wizard from the start menu 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, execute the cmdlet below in the SharePoint Management Shell.

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

Once executed, the BDC database status turned to “No Action Required”. Let’s see another similar issue:

In SharePoint Server 2016 Central Administration, under the database upgrade status page, found the status of a SharePoint central admin 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:

Upgrade the Content Databases

Open SharePoint Management Shell and run the cmdlet “Upgrade-SPContentDatabase” on the content database once, which should resolve the problem.

Get-SPContentDatabase -Identity <database-name> | Upgrade-SPContentDatabase

Change the <database-name> with the specific content database name. To upgrade all content databases, that need to be updated:

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

Run the SharePoint 2016 Configuration Wizard via SharePoint Management Shell

Navigate to location “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\BIN” and run PSConfig command line:

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

Reanalyze the SharePoint health analyzer issue to confirm it’s sorted.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the 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

Your email address will not be published. Required fields are marked *