Steps to upgrade Sharepoint SQL Server version to latest version (not Sharepoint version)

Kalachand 1 Reputation point
2021-05-19T22:04:20.773+00:00

Steps to upgrade Sharepoint SQL Server version to latest version (not Sharepoint version)

OS: Windows 2012 R2

SQL Server | Other
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-05-20T02:38:10.813+00:00

    Hi @Kalachand ,

    SQL server 2019 is the latest version for SQL server. According to MS document Operating system support for SQL 2019, Windows 2012 R2 is not in the OS supported list. But SQL server 2017 is compatible with Windows 2012 R2. Refer to the MS document Operating system support for SQL 2016 and SQL 2017. So you can upgrade SQL server to SQL 2017 or upgrade OS to windows server 2016, then upgrade SQL to SQL 2019.

    For upgrading SQL server, you need to check whether the current SQL server version supported to upgrade to SQL 2017 or SQL 2019. Refer to Supported version & edition upgrades (SQL Server 2019 or SQL 2017). Suggest you back up the databases before upgrading.

    Please refer to the MS document Upgrade SQL Server Using the Installation Wizard (Setup) to get detail steps and more notes.

    This is SQL server tag in Q& A, I am not familiar with SharePoint. For other notes about SharePoint after you have new SQL server version. I search for this. Please check the suggestions form below links.

    Upgrade SharePoint 2013 database server from SQL server 2008 R2 to SQL server 2012 R2
    Upgrading SQL Server from 2008 R2 to 2014 for SharePoint 2013


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.