Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Does Sharepoint Differential backup put the site collection in read only mode?

share|improve this question
    
anybody exp with diff backup –  sharepointde1tuke Dec 9 '10 at 23:20

3 Answers 3

Actually, that's going to depend on what release and build version of SharePoint you're using.

  • If you have a SharePoint 2007 farm that hasn't yet been patched to Service Pack 2, you're going to have to manually lock the site collection before you back it up, regardless of whether its a Full or Differential backup. (And for goodness sakes, please patch it up to Service Pack 2 and the latest Cumulative Update as soon as you can!) This blog post has a nice writeup of what was introduced in Service Pack 2: http://sharepointblog.michaelrperry.com/2009/06/stsadm-backups-with-service-pack-2.html
  • But if you have at least Service Pack 2 of MOSS 2007 or SharePoint 2010, SharePoint will now automatically lock the targeted item before backing it up and then unlock it once the backup is completed. If you don't want to lock the site, use the -NoSiteLock switch in your call to Backup-SPSite (this works w/ SharePoint 2010, not sure if there is an equivalent option w/ SharePoint 2007 or not)

John

share|improve this answer
    
Thanks John. I knew you'd know. –  Rob Wilson Dec 12 '10 at 0:29
1  
Also note if you backup using PowerShell you can also specify -UseSqlSnapshot. This will take advantage of the SQL Snapshot feature and ensure that the data is consistent and not changed during backup and not put your Site Collections in read-only mode. –  Wictor Wilen MCA MCM MVP Sep 20 '11 at 6:09
    
Good explanation about when locks apply, though you can't do a differential site collection backup... –  shufler Nov 14 '11 at 21:24

I don't think it was intentional, but this is actually something of a trick question. Let me explain.

There are basically two different types of backups that you can perform: farm-level (catastrophic) backups and site collection backups. The former is used to back up components such as the entire farm, a Web application, a content database, etc. The latter, on the other hand, is used to back up an individual site collection. Each backup type is implemented and conducted differently within the SharePoint Object Model.

To help tell them apart:

  • Farm-level backup: STSADM.exe -o backup -directory <UNC path> or Backup-SPFarm (for 2010)
  • Site collection backup: STSADM.exe -o backup -url <URL> or Backup-SPSite (for 2010)

So, here's the tricky part: full-farm backups can be carried out in full or differential mode, but site collection backups can only be carried out as a full backup. There actually isn't any "differential site collection" backup using out-of-the-box tools.

John Ferringer's answer is absolutely correct for site collection backups, but I'm guessing that you were probably asking whether or not your site collections (any of them) would become locked (i.e., placed in read-only mode) if you were to carry out a differential farm-level backup that included content databases where site collections are housed. The answer in that case is "no." Those backups are not handled in the same was as site collection backups, and so there isn't the same need to lock site collections.

share|improve this answer
    
+1 This is a very good point about the distinction and explaination. –  shufler Nov 14 '11 at 21:23

No, you would need to set it yourself before performing the backup.

Edit: See John Ferringer's response. My answer was deprecated with the release of MOSS 2007 SP2.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.