Move Sharepoint Databases To New SQL Server

SQL Server is a relational database service on the leading market of the SQL Server engine. It provides various performances, business continuity, scalability with no downtime, data protection etc. It is mainly used on the organization platforms for data integration, data analysis, and processing components. It is very stable, popular, affordable, as well as a fast database engine. In the following section, we will discuss the need to move SharePoint Databases to new SQL Server.

Also, read:
Create web part page using visual studio 2013 in SharePoint 2013

Delete List View using PowerShell in SharePoint 2013 and Set List View as Default view using PowerShell SharePoint 2013

Redirect to a different page in SharePoint 2013 using JavaScript or jQuery

Why Do Users need To Move SharePoint DB to SQL Server?

SharePoint is a web-based application, which enables an organization to work more professionally by allowing the users to share the data, information, and documents. There are various SharePoint products for an organization, which offers a unique set of advantages to users. However, there is some circumstance that is faced by users while using SQL Server such as – SharePoint has some file size limitation because of which it creates a problem in synchronization of the file. It even blocks some file types to be uploaded on SharePoint. It does not have any profile pages for any external content type. It does not work in offline mode; it needs proper internet connectivity to work. Even, it does not have any search integration. To overcome such shortcomings, many users are moving their data from SharePoint databases to new SQL Server.

How to Move SharePoint Databases to New SQL Server?

The user can easily move the SharePoint database to a new SQL Server by following the steps given below:
– Run CMD in administration mode
– Type the following command:

c:\windows\system32>cliconfg.exe

– Now a client-server-client network utility window will appear, enable the TCP/IP on it.
– Select Alias >> Add > type the same name for server >> OK
– Open SharePoint management shell and type a command

psc:\users\mradwan\get-database

– Now the entire database for SharePoint will be listed.
– Copy all the GUID and paste it into a notepad file.
– Now type a command on SharePoint management shell

psc:\users\mradwan>$db-get-spdatabase

– Write the following command and then type an update command

psc:\users\mradwan\$db.ChangeDatabaseInstance<“TFS”


– Follow the above two steps for all GUID’s
– Now, Start all the SharePoint services that were stopped earlier
– Open SQL administration and enter credentials.
– Now, you can easily view your entire SharePoint database in SQL Server.The above blog discusses a procedure for migrating SharePoint database to SQL Server with the combined usage of CMD and PowerShell. Users need to use cmdlet for moving the data from one database to a new server however, a set of requirements need to be fulfilled beforehand to make the procedure feasible.

Hope this will be helpful.


You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →