If you are running SharePoint 2013 and you are seeing:
Databases running in compatibility range, upgrade recommended
then one of two things happened:
- You upgraded from a SharePoint 2010, and/or;
- You installed the March 2013 SharePoint 2013 Uber update
The ‘fix’ is far from straight forward but it is also not difficult:
- In SharePoint Central Admin click BACKUP AND RESTORE, then PERFORM A BACKUP and do what is obvious
- Start the SHAREPOINT 2013 MANAGEMENT SHELL (make sure you RUN AS ADMINISTRATOR
- CD into C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\BIN>
- Paste following command and press enter PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
- this will take a few minutes to complete, so just wait
- Go back to your SharePoint Central Admin console and click MONITORING (left menu) >REVIEW PROBLEMS AND SOLUTIONS > if Databases Running in Compatibility Range, Upgrade Recommended still shows click on it and then click the REANALYZE NOW button on the top
- Hopefully it only complains about your content database and Bdc_Service_DB .
To upgrade your Content Database:
- Paste the following into your SharePoint 2013 Management Shell Upgrade-SPContentDatabase and then enter the name of your content database at the Identity
To upgrade your Bdc_Service_DB:
- Paste the following into your SharePoint 2013 Management Shell (Get-SPDatabase | ?{$_.type -eq
“Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase”}).Provision()
I found that if I clicked the REANALYZE NOW button in the Console, some of the databases still showed as needing an upgrade. However if I went back to SharePoint Central Admin console and click MONITORING (left menu) >REVIEW PROBLEMS AND SOLUTIONS that the databases warning was gone… so I was happy.
Thanks to Amos at Microsoft Partner Support for his assistance. The following blogs were also used as references
7 Comments
Tahlia · November 30, 2015 at 9:20 am
A lot of people get this error and a year later on, they still have
absolutely nothing much showing for energy and absolutely nothing uploaded to YouTube.
Scott · October 27, 2015 at 8:29 am
Two years old and this post still saved me, several times.
Ishfaque Ahmed Memon · October 1, 2015 at 3:31 am
Nice Article. Keep it up. Your help is appreciated
Martin · February 10, 2015 at 12:19 pm
great post , thanks !
Robert · October 1, 2014 at 10:35 am
Thanks! Frustrating that so many admin things in Sharepoint still have to be figured out like this.
Databases running in compatibility range | Life of a Programmer Girl · December 19, 2014 at 6:33 am
[…] SOLVED, COMPLETELY – How to Clear “Databases Running in Compatibility Range, Upgrade Rec… […]
Always On Availability Groups and SharePoint 2013 – Leaves Something to be Desired | The Masked Administrator · September 25, 2014 at 7:31 am
[…] A great guide on upgrading your databases using the above command is here. […]