RathanSharepoint on Thu, 31 Dec 2015 20:15:11

Hi Team,

I want to migrate SharePoint 2013 from one location to another. its includes SQL, AD account and all other settings. Could you please guide me what is the best practice to do the migration SharePoint2013 and SQL Server. (SQL Server 2012 to SQL Server 2014)

I am using 3-tier Architecture environment.(SQL, App-server and Front Server.)

Best regards,



Sara Fan on Fri, 01 Jan 2016 02:33:35

Hi Rathan,

You could backup and restore the SharePoint farm by PowerShell, central administration or SQL Server tools.  And you also could move all databases in SharePoint to another server.

For more detailed information, you could refer to the articles below.

Back up farms in SharePoint 2013.

Restore farms in SharePoint 2013.

Move all databases in SharePoint 2013.

Moving SharePoint Databases to Another Server (Without Reconfiguring SharePoint).

Best regards,

Sara Fan

RomanMulley on Mon, 04 Jan 2016 07:13:01

The above suggestion looks good to get this job done. Moreover, you may also take help from below given references:

Simple Guide to Moving SharePoint Content Databases to a New Server:

Backup and Restore a SharePoint 2013 Farm Configuration:

Migrating Team Foundation Server 2013 Databases and all Databases in SharePoint 2013 to a New Server:

Migrating SharePoint database instance to another server:

Additionally, If you wish you may also check this SharePoint content migration solution

Hope it helps you!