Viftech Page Loader

SharePoint Backup Best Practice

A backup is a copy of data that is used to restore and recover that data after a system failure. While backups allow you to restore data after a failure they are also useful to keep for routine purposes. These purposes include copying a database from one server to another, setting up database mirroring, and archiving to comply with regulatory requirements.

Types of backup in SharePoint 2013

  • Farm Backup
  • Site Collection Backup

Farm Backup

The farm backup architecture in SharePoint 2013 starts a SQL Server backup of content and service application databases, writes configuration content to files, and also backs-up the Search index files and synchronizes them with the Search database backups.

To back up a farm by using PowerShell command
          Backup-SPFarm -Directory <BackupFolder> -BackupMethod {Full | Differential} [-Verbose]
To back up a farm by using Central Administration

  1. To perform this procedure, you must be a member of the Farm Administrators group on the computer that is running Central Administration.
  2. In Central Administration, on the Home page, in the Backup and Restore section, click Perform a backup.
  3. On the Perform a Backup — Step 1 of 2: Select Component to Back Up page, select the farm from the list of components and then click Next.
  4. On the Start Backup — Step 2 of 2: Select Backup Options page, in the Backup Type section, select either Full or Differential.

Site Collection Backup

This Backup is called Granular backup. The architecture uses Transact-SQL queries and export calls. It will create .bak file for restore Site. Granular backup and export is a more read-intensive and processing-intensive operation than farm backup. It will backup the whole website including Libraries, Lists, and workflows, etc.
To backup a site collection using powershell command
Backup-SPSite <URL of your site> -Path <file path to store backup file>
for  e.g :  Backup-SPSite http://yoururl/ -Path C:\Backup\site_name.bak

Daily Backup Site Collection Scheduler

Following Steps are required to run site collection backup daily.

1. Create new file in notepad and copy this text.
#Backup location
$backupLocation = “C:\\”
#Site collection location
$sitecollection = http://yoursitename/
#daily backup filename
$dailybackupfile = Join-Path -Path $backupLocation -ChildPath (“yourfilename_” + (Get-Date -UFormat “%Y-%m-%d-%A”) + “.bak”)
$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
}
Backup-SPSite -Identity $sitecollection -Path $dailybackupfile –Force
copy $dailybackupfile –Force
2. Save file as with “.ps1” extension
3. Open window Task Scheduler

1) Open Task Scheduler
2) Create New Task
3) Enter Task Name
4) Select Task Schedule
5) Set Backup timing
6) Select Task Type
7) Set path of powershell script file
8) Finish
9) Backup will run every day at the time you specified.

# Tags:

Close

Leave a Reply


Similar Blog Articles

How Much Does SharePoint License Cost?

SharePoint is truly one of the world’s most incredible platforms for any organization. It allows workers to share and handle content, and data enabling better teamwork. By acquiring a SharePoint license, you get the chance to manage your content effectively, and it also helps to improve the productivity of your business. SharePoint allows dynamic teams to connect and collaborate on projects efficiently. They can share files, data, and information, […]

Rating — 5 (2 voices) by developer on August 21, 2019

How Microsoft SharePoint Can Benefit Your Small Business

Since 2001, Microsoft SharePoint has been around us, and in all these years, it performed so well to become the foremost collaboration resource choice for the top business enterprises. The release of SharePoint 2007 enabled businesses to harness the online collaboration powers, while the release of SharePoint 2016 offered countless new proficiencies to the IT […]

Rating — 5 (2 voices) by developer on July 4, 2019

Best Content Migration Tools for SharePoint

It is only a matter of time until a decision is made to migrate from an older version of SharePoint to the latest version of SharePoint, or even from a different enterprise content management (EMC) to the newest version of SharePoint. Below we have mentioned some of the best SharePoint migration tools that will help […]

Rating — 5 (2 voices) by developer on May 29, 2019

YOU'VE GOT

A PROJECT IN MIND

WHAT'S NEXT?

Sent us a message with a brief description of your project. Our expertteam will review it and get back to you within one business day withfree consultation and to discuss the next steps.