My SQL Server of SharePoint 2013 environment is having an Obsolete version of SQL and if i upgrade the version of it will it affect us anyway to the server or data or functionality or configurations?

Please help me

  • what version of SQL u are using?
    – Waqas Sarwar MVP
    Commented Oct 11, 2017 at 17:05

2 Answers 2


SharePoint 2013 supports SQL Server 2014, SQL Server 2012, and SQL Server 2008 R2 SP1+. You can certainly do an in-place upgrade, which I've had success with in the past on non-production systems.

You can also build out a new SQL Server running one of the above versions and move the databases to it. Follow this article to perform that process: Move all databases in SharePoint 2013.

  1. Schedule a Downtime for the SharePoint I will stop the IIS & timer services so that no connection should make to SQL server while patching.
    1. Apply the Patch to SQL server, test and verify it.
    2. Bring the SharePoint Server back online. Test it. Test this in the lower environments and then schedule it for production. 1st.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.