Wednesday, 17 October 2018

Migrate SharePoint SiteCollections from one farm to another farm using Content Database

SharePoint Site collection can be moved to another farm or location using site collection backups or Content database back up.

If you required only one sitecollection then we can backup site collection using powershell or SharePoint central admin.

in my cases i have 2 site collection in one web application and both are using same content database.

I use Content database method.

Step 1 : backup Content Database from SQL Server.


Step 2: Restore Content database to new SQL Server (new Loction)
 








Step 3: Mount-SPContentDataBase
           
if you don't have existing web application please create new web application  and mount your database to web application, it will use the same managed path as you have in original location.

Mount-SPContentDatabase "WSS_Content_MyDB" -DatabaseServer "DEVVMSPDB01\SP2013DB" -WebApplication http://devvmspap01:15734/