SharePoint 2010 Cookbook: Backup a Site Collection Automatically with a PowerShell Script

One of the most important things that all SharePoint users, and especially administrators, should do regularly is back up data. Nevertheless, it is often overlooked by many people just because the process might seem to take hours, and we don't have the time or the inclination to run backups on a regular basis. In recognition of this behavior, what if there was a script for backing up SharePoint data which could be scheduled to run automatically? Now that's a whole different story! In this post, I will demonstrate how to back up a SharePoint 2010 site collection automatically through the use of a PowerShell script.


How can I backup a SharePoint 2010 site collection automatically on a regular basis?


For the sake of this exercise, I'm going to assume that you already have a backup location setup. Let's say it's "C:\Backup\MySite".

First, verify that you possess the following permissions:

  • SharePoint Farm Administrator.
  • Local Server Administrator on all Web servers.
  • db_owner permission on the content database.
  • Full Control permission on the backup folder.


Step 1: Create a PowerShell script for backing up a site collection (BackupSite.ps1):

Add-PsSnapin Microsoft.SharePoint.PowerShell
Start-SPAssignment -Global            # This cmdlet takes care of the disposable objects to prevent memory leak.
$mySite="http://mySite"            # Replace with your site collection URL
$backupLocation="C:\Backup\MySite"        # Replace with your backup location
$logFile="$backupLocation\BackupLog.log"    # Replace with your desired log file location
$today=Get-Date -format "MM-dd-yyyy"    # Get current date and format it to avoid invalid characters such as "/" and ":"
write-Host Start backing up $mySite to $backupLocation
    # Create a new backup file and name it based on current date. If you want to create only 1 backup file and overwrite it each time the backup is run, you can replace "$today.bak" with your desired file name.
    Backup-SPSite -Identity $mySite -Path $backupLocation\$today.bak -force -ea Stop
    write-Host Backup succeeded.
    # Write success message to the log file
    write "$today    $mySite successfully backed up.">>$logFile    
catch        # If the process failed
    write-Host Backup failed. See $logFile for more information.
    # Write error message to the log file
    write "$today    Error: $_">>$logFile
Stop-SPAssignment -Global
Remove-PsSnapin Microsoft.SharePoint.PowerShell
write-Host "Finished script."


Basically, the above script will do the following:

  • Assign all the needed information to start backup.
  • Try to create a new backup and name the file based on current date.
  • If successful, it will write a success message to the log file. Otherwise, it will log the error/exception.


Step 2: Create a batch file to run the script (RunBackup.bat):

cd /d %~dp0
powershell -file    ".\BackupSite.ps1"

Step 3: Copy both the script and batch file to a folder on the SharePoint Server.

Step 4: Run the batch file to start backing up the site collection immediately or use Windows Task Scheduler to schedule it.

I have attached both the script and the batch file at the end of this post for your convenience.



  • This method works with both SharePoint 2010 Foundation and Server.
  • While performing the backup, the SharePoint site collection will be set to Read-Only to prevent data corruption, so it's recommended that you run this script during off-peak hours.

See Also:

Posted Dec 21 2010, 01:00 PM by Duy Do


jakistra wrote re: SharePoint 2010 Cookbook: Backup a Site Collection Automatically with a PowerShell Script
on Mon, Mar 14 2011 1:59 PM

in the Backup-SPSite cmdlet, what does the "-ea Stop" do?


Add a Comment

Please sign into Bamboo Nation to leave a comment.
Bamboo Solutions Corporation, 2002-2015