Backup instructions for Site Collection, read TechNet http://technet.microsoft.com/en-us/library/ee748617(office.14).aspx
I want to backup the site collection daily and keep a backup of every week of the year. I created a Powershell script and scheduled the script.
The Powershell script does the following:
- checks if SharePoint Powershell Snapin is loaded;
- checks if backup location exists;
- backups the site collection;
- copies the daily backup to the weekly if necassary;
The ‘Backup Site Collection.ps1’ code:
"-------------------------------------"
"Yellow & Red SharePoint Backup script"
"-------------------------------------"
"- One daily backup"
"- And weekly backup"
#Backup location
$backupLocation = "\\XXX\d$\_backups\XXX\"
#Site collection location
$sitecollection = "http://XXX"
#daily filename
$dailybackupfile = Join-Path -Path $backupLocation -ChildPath "backup_yarintranet_daily.bak"
#weekly filename (using uformat as format doesn't have week option)
$weeklybackupfile = Join-Path -Path $backupLocation -ChildPath ("backup_yarintranet_" + (Get-Date -UFormat %Y%W) + ".bak")
# check to ensure Microsoft.SharePoint.PowerShell is loaded
$snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'}
if ($snapin -eq $null) {
Write-Host "Loading SharePoint Powershell Snapin"
Add-PSSnapin "Microsoft.SharePoint.Powershell"
}
if(!(test-path $backupLocation -PathType Container))
{
"Backup location (" + $backupLocation + ") not found."
break
}
"Starting backup process"
Backup-SPSite -Identity $sitecollection -Path $dailybackupfile -Force
"Finshed backup process"
"Copy daily backup to weekly if necessary"
if((test-path $weeklybackupfile -PathType Leaf))
{
"Weekly backup file found, so no backup will be made"
break
}
copy $dailybackupfile $weeklybackupfile -Force
"Finished"
Schedule the a task using the Windows 2008 scheduler.
Make sure that:
-
you set the correct Identity that has access to the backup location;
-
task runs even when user is not logged in;
-
Set interval of script execution in ‘Trigger’ tab;
In ‘Action’ Tab set the execution of the Powershell script:
-
Program/script: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
-
Arguments: -file "<full path location to your Site Collection backup Powershell script>" (exclude the <, include the ")
And as always, make sure you test your backup. Otherwise you’ll have a very bad day when disaster strikes.
