How to Backup and Restore the Site Collection with Specific Content Database using PowerShell in SharePoint 2013

Sathish Nadarajan
 
Solution Architect
August 24, 2015
 
Rate this article
 
Views
27421

In the previous article, we saw how to create site collection on a particular Content Database. The objective of that is to create the site collection on specific DB is about the maintainability. How easy to take the Backup and Restore.

Now, in this article, let us see how to backup and restore using PowerShell. Both of them are one liner. Though it is very simple, I just wanted to keep this handy for the user who is in search for this.

The below line will do the Backup.

 Backup-SPSite http://MyWebApplication/sites/mysiteCollection/ -Path D:Test.bak –UseSqlSnapshot

To restore the above backup,

 Restore-SPSite -Identity http:// MyWebApplication/sites/mysiteCollectionNew  -Path "D:Test.bak" -ContentDatabase MyDB  -Verbose

This will restore the BAK File into a new Site Collection. This SiteCollection will get created automatically. We don’t need to create a blank site collection and restore. If you do that, then you will end up with an exception stating that, the site already exists. Technically, this restore is doing a site creation.

 

Happy Coding,

Sathish Nadarajan.

Category : PowerShell, SharePoint

Author Info

Sathish Nadarajan
 
Solution Architect
 
Rate this article
 
Sathish is a Microsoft MVP for SharePoint (Office Servers and Services) having 15+ years of experience in Microsoft Technologies. He holds a Masters Degree in Computer Aided Design and Business ...read more
 

Leave a comment