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 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:BackupMySite”.

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:BackupMySite"        # Replace with your backup location
$logFile="$backupLocationBackupLog.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:

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?


All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019


Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.

Essentials Suite

Essentials Plus Suite

Bamboo Premier Suite

Project Management Suite

Knowledge Management Suite

External User Manager


For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!