How to move sharepoint database to new db server.

Question

I am planning to move sharepoint database to new sql server cluster with dns name not thru the alias name.... what is the recommended way to do... any help is appreciated??? In open source documents... all are describing about how can we change the connection thru alias but we want to know about DNS approach... how can we move all database to new availability server and change the connection string...btw i m using SP 2016.

Rahul Khanna · Answer

Here we are changing the connection string of sharepoint and intacting the database name as same as before... There is no direct way to do this changes.... For each migrated database we need to use the powershell command to map to the new sql server.... and change the default database name to new sql server.. this is how I did and it worked.... This information may be helpful to someone else as well..

Nanddeep Nachan · Answer

You can migrate SQL DB to new server. Once done, from SharePoint central admin map the migrated DB to corresponding web application.