Monday, September 15, 2014

Database is in compatibility range and upgrade is recommended



Database is in compatibility range and upgrade is recommended

Issue: Database is in compatibility range and upgrade is recommended

Solution: Please find the below solution to upgrade the SharePoint DB.

1.    In SharePoint Central Admin click BACKUP AND RESTORE, then PERFORM A Full BACKUP.
2.    Start the SHAREPOINT 2013 MANAGEMENT SHELL (make sure you RUN AS ADMINISTRATOR
3.    CD into C:\Program Files\Common Files\Microsoft shared\Web Server Extensions\15\BIN>
4.    Paste following command and press enter PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
5.    this will take a few minutes to complete, so just wait
6.    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
7.    Hopefully it only complains about your content database and Bdc_Service_DB

How To upgrade your Content Database:
  1. Paste the following into your SharePoint 2013 Management Shell Upgrade-SPContentDatabase and then enter the name of your content database at the Identity
How To upgrade your Bdc_Service_DB:
  1. Paste the following into your SharePoint 2013 Management Shell (Get-SPDatabase | ?{$_.type -eq
    “Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase”}).Provision()
Data base is up to date but some sites are not completely upgraded:


 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

1 comment:

Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula

ShareThis

X