How to upgrade Sharepoint SQL Server 2017 to SQL 2019

Question

What are the steps to be taken to Sharepoint if we are to upgrade its SQL Server databases from SQL server 2017 to SQL 2019. We have an existing SQL 2019 instance and that's where we are going to restore/migrate the databases related in sharepoint. Are there any steps to modify that will link the sharepoint to its new database?

Answer 1

Hi @Annaliza T. Bañaga 

Thank you for posting your question in the Microsoft Q&A forum. 

When migrating SharePoint databases to a new SQL Server instance, the first step is to stop all SharePoint-related services across the farm. This ensures that no active connections remain during the transition. You can follow the official guidance here: Start or stop a service in SharePoint Server - SharePoint Server | Microsoft Learn 

Next, back up all SharePoint databases from the old SQL Server and restore them to the new one. Before restoring, make sure your farm account and service accounts have the required permissions on the target SQL Server. This includes transferring all SQL logins and passwords from the old server to the new one. Microsoft provides a helpful guide for this: Transfer logins and passwords between instances - SQL Server | Microsoft Learn 

Once the databases are restored, update or configure the SQL alias to point to the new server. You can follow the steps outlined in How to change the database server in a SharePoint farm - SharePoint | Microsoft Learn 
Finally, restart the SharePoint services you stopped earlier, and verify that your farm and sites are operating as expected.  
Reference: Move all databases in SharePoint Server - SharePoint Server | Microsoft Learn 

Please note that as forum moderators we primarily test with SharePoint Online. The steps above are based on Microsoft’s official documentation for SharePoint Server rather than hands-on configuration. 

We appreciate your understanding and hope this guidance helps you complete your migration successfully. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

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.