Move Sharepoint Databases To New SQL Server

InfoPath alternatives for form designing SharePoint

SQL Server is a relational database service on the leading market of 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 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 different page in SharePoint 2013 using JavaScript or jQuery

Why 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 are some circumstance that are 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 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 at offline mode; it needs proper internet connectivity to work. Even, it does not have any search integration. To overcome from such shortcomings, many users are moving their data from SharePoint databases to new SQL Server.

How to Move SharePoint Databases to New SQL Server?
User can easily move the SharePoint database to 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

ps c:\users\mradwan\get-spdatabase

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

ps c:\users\mradwan>$db-get-spdatabase

– Write the following command and then type an update command

ps c:\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.

Conclusion
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.

Similar SharePoint 2013 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 →

Leave a Reply