Sunday, April 08, 2018

When to use UsesqlSnapshot with Backup command

Here is the tips and best practice you can follow while taking backup your SharePoint site collection.

Consider the scenario, your site collection is very huge and wanted to take the backup using SharePoint PowerShell command BackUp command and in peak hours, where your users are continuously working on it.


Backup-SPSite http://server/sites/myteam -path D:\SiteBackUp\08-04-18_myteam\08-04-18_myteam.bak

When you using the above command, your site being locked and set to read-only until site backup job completes, So your will see the performance problem and cannot add anything to your site collection.



Backup-SPSite http://server/sites/myteam -path D:\SiteBackUp\08-04-18_myteam\08-04-18_myteam.bak -UseSqlSnapshot

When you use the backup-spsite parameter -UseSQLSnapshot, while backup process is on all the transaction will be saved it SQL Snapshot and later it will update back to respective site collection's content database and the SQL Snapshot will be deleted and free your storage and resources.