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

Sathish Nadarajan
SharePoint MVP
Published On :   24 Aug 2015
Visit Count
Today :  13    Total :   12638
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

Sharegate: Kick-Ass Tool
Think Your SharePoint & Office 365 Are Secure ? Find Out Now!

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.

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.

Migratiin Tools for SharePoint