question

Kalachand-6244 avatar image
0 Votes"
Kalachand-6244 asked Cathyji-msft commented

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

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

OS: Windows 2012 R2

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Kalachand-6244,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @Kalachand-6244,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.