Various Technologies, ranging from SharePoint to SQL, are changing day-by-day and it requires hell lot of effort for organizations to plan their database server migration. Many companies, whether big or small, always think of effective migration of their SharePoint Database server using strategic innovation approach to accomplish high-productivity and minimal effort. Yet, the hopeless truth is that various SharePoint Database migrations are seen as calamities by the companies even though data transfers from one location to another. Therefore, the real question arises – Why it is so difficult to successfully migrate SharePoint databases from one server that is running SQL Server to another.

So what is the answer to this question?

The answer lies in the fact that most of companies fail to reconfigure SQL server with the SharePoint. Therefore, in order to successfully execute the migration of the SharePoint Server databases, it is paramount to reconnect the SharePoint Server with new database server. This blog shows the example of the SharePoint Server 2013. But this can be applied to other servers also.

Migrations of the SharePoint Server databases includes:

1. Create new SQL server instance on new database server.

2. Backup of all the SharePoint server databases from the old database.

3. Restore all the SharePoint server databases to the new database server instance. (Recommended – Stop all the SharePoint sites during backup and restore databases and process to avoid the loss of data)

4. Configure the SharePoint Server again to change the database server configuration.

Now, let’s start with the mapping of our SharePoint Server with the new database server. For this, we follow the below steps to proceed.

5. Open Windows Services from Start or can use the Run with “services.msc” command.

Windows Services-Run

6. Stop all the SharePoint Services.

  • SharePoint Administration
  • SharePoint Timer
  • SharePoint Tracing
  • SharePoint User Code Host​​
  • SharePoint VSS Writer
  • SharePoint Foundation Search V4
  • World Wide Web Publishing Service
  • SharePoint Server Search 15

7. Create SQL Server alias for pointing to new SQL database server on all your SharePoint servers.

If SQL Configuration Manager is installed just head over to the SQL Native Client 10.0 configuration then into Aliases. Create a new alias that points to your new SQL Server by right clicking on the Alias. You need to do this on both 32- and 64-bit instances.

  • On the Alias name put your old SQL Server IP or Name
  • On the Port the port you indicated on step 7; default is 1433.
  • Protocol should be TCP/IP
  • And on Server the new SQL Server IP or Name together with its instance name if there is any. In our case it’s SQL2012​

If you don’t have SQL Configuration Manager in your SharePoint Server then run the CLICONFIG again on both 32- and 64-bit instances. For 32-bit go to run command and execute this “%SystemRoot%/SysWow64/CliConfg.exe” and for 64-bit just this “CLICONFG” all without quotes of course. Add the same information as above.

8. Now the next step is to rename the old database server name with the new database server name in SharePoint. For this, we will use the SharePoint PowerShell command. Simply type the following command for this change.

Replace “OLDSQLSERVER.DOMAIN.COM” with your old server database name including the domain.

Replace “NEWSQLSERVERNAME.DOMAIN.COM” with your new server database name including the domain.

9. Well, now main tasks are completed, now we just have to run our services again and need to check whether all are connected perfectly or not. For this, we first now start all SharePoint Services from the Windows services.

  • SharePoint Administration
  • SharePoint Timer
  • SharePoint Tracing
  • SharePoint User Code Host​​
  • SharePoint VSS Writer
  • SharePoint Foundation Search V4
  • World Wide Web Publishing Service
  • SharePoint Server Search 14

10. Once all the services are up, check in the Central Administration site, whether old SQL server is renamed to the new SQL server name. Voila, its changed.

11. Now, stop all SharePoint services again like in step 6.

12. Delete SQL alias which was created in step 7.

13. Start all SharePoint services similar in step 9.

14. Finally, check whether all databases are connected to new databases. Viola, it’s all connected to the new databases and all sites are now working perfectly.


–  Rashi Chauhan


Get a Quote