Search This Blog

Monday, March 7, 2011

Granular Backup and Restore in SharePoint 2010

Problem

 Backup and Restore in SharePoint 2010, I talked about options to backup a SharePoint farm, web applications and different components and then restore them back whenever required. But what if I have a web application with multiple site collections in it and one of the them is only getting changed frequently hence I want to backup only a specific site collection instead of backing up the complete farm or web application on regular basis? What if I want to create a copy of the site collection to another SharePoint server? What new options are available in SharePoint 2010 for site collection backup and restore?

Solution

SharePoint 2010 not only allows you to backup and restore the farm/web application/services but also supports granular backup. For example you can take a backup of any specific site collection from Central Administration. You can export site content to the file system and import it into another site. And yes, now you don't need to setup another temporary farm to just restore a small part of your site content from the backup. You can simply restore a content database on any SQL Server instance and then use the unattached content database recovery feature from Central Administration to restore the selected contents.

This tip will discuss how to backup a SharePoint site collection from Central Administration as well as from PowerShell and the STSADM command as well as restoring it back using PowerShell or the STSADM command.

Backing-up a Site Collection from Central Administration

Go to:

START -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Central Administration.

On the left side click on the Backup and Restore link as shown below, then in the detail pane click on Perform a site collection backup under Granular Backup as shown below. Please note Central Administration only allows you to take a backup of a site collection, you need to use PowerShell or the STSADM tool to restore it back when required (discussed next):


On the Site Collection Backup screen, specify the name of the site collection you want to take a backup of, the location to store the backup, the name of the backup file and the option to whether overwrite a file if it exists with the same name on the specified location. You can change the site collection selection by clicking on the Change Site Collection button.



On the Granular Backup Job Status screen, you can see the status of the site collection backup operation. This page gets refreshed automatically in every 30 seconds though you can refresh it on-demand by clicking on the Refresh link as shown below (You need to make sure the SharePoint 2010 Timer windows service is running before making a site collection backup using Central Administration):


Backing-up and Restoring Site Collection using PowerShell cmdlets

Central Administration is not the only way to do site collection backup in SharePoint 2010. SharePoint 2010 provides several PowerShell cmdlets to perform these operations. In other words you can script these operations and schedule it with Windows Task Scheduler to make it run on scheduled basis. Let's explore these cmdlets in detail.

The Backup-SPSite command is used to backup a site collection whereas the Restore-SPSite command is used to restore a site collection. The general syntax of these commands are:

Backup-SPSite -Identity <url of the site collection to be backed up> -Path <location and name of the file to be created after backup> [-Force] [-Verbose]


Restore-SPSite -Identity <url of the site collection getting restored> -Path <location and name of the backed up file to restore from> [-Force] [-Verbose]


To launch SharePoint 2010 the PowerShell console, go to:

START -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell and click on it.

To take the site collection backup we need to use the Backup-SPSite command and specify the location where the backup will be stored, and the URL of the site collection. The Force parameter is used to overwrite a file with same name (if it exists) during the backup and overwrite a site collection with same name (if it exists) during a restore operation:

Backup-SPSite -Identity http://vens2k8r2:8081 -Path \\VENSIW2K8R2\SharePointBackupFolder\PrimarySiteCollection.bak -Force


Restore-SPSite -Identity httpvens2k8r2:8081 -Path \\VENSIW2K8R2\SharePointBackupFolder\PrimarySiteCollection.bak -Force
 




Backing-up and Restoring Site Collection using STSADM (SharePoint Administrative) tool

STSADM is a SharePoint administrative tool which generally resides in...

 "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN"
...on a SharePoint 2007 server and in...

"C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN"
...on a SharePoint 2010 environment.

This command is run on the server, by the people who are member of Administrators group. In this section we are going to see how this tool can be used to backup a site collection and restore it back when required. These are general command formats for abackup and restore of site collection.

stsadm -o Backup -URL <url of the site collection to be backed up> -Filename <location and name of the file which gets created to store backed up data> -Overwrite


stsadm -o Restore -URL <url of the site collection to restore to> -Filename <location and name of the backed up file to restore from> -Overwrite
 
The Overwrite switch is required to overwrite a file if it already exists on the specified location during a backup operation and, similarly, overwrite a site collection if it already exists with same name on the specified URL during restore operation. To learn about the parameters of this command, follow this link.

stsadm -o Backup -URL http://vens2k8r2:8081 -Filename \\VENS2K8R2\SharePointBackupFolder\PrimarySiteCollection.dat -Overwrite


stsadm -o Restore -URL http://vens2k8r2:8081 -Filename \\VENS2K8R2\SharePointBackupFolder\PrimarySiteCollection.dat -Overwrite
 
 




Notes

  • Please note: Though you can still use old the STSADM (SharePoint Administrative) tool to perform backup and restore operations it is not recommended to use this tool (unless you are forced to use it for backward compatibility) as this tool has been deprecated and provided in SharePoint 2010 only for backward compatibility. To learn more about mapping between STSADM and PowerShell cmdlets, click here.
  • To improve the performance of backup/restore operations, use a local path to minimize the latency; if required you can then move a backed up file to a network location after a backup completes or before a restore you can move from a network location to a local path and then start restore operation.
  • If your SQL Server version supports a database snapshot (Enterprise and Developer editions) , it is recommended to use the UseSqlSnapshot parameter with the Backup-SPSite command for a more consistent backup.
  • Additional related PowerShell cmdlets are, Get-SPSite, Move-SPSite, New-SPSite, Remove-SPSite, Set-SPSite, Get-SPSiteAdministration etc.
  • You need to make sure the SharePoint 2010 Timer windows service is running before taking a site collection backup using Central Administration.
  • The recommended maximum size for a site collection backup is 15GB in SharePoint 2007 and 85GB in SharePoint 2010.
 

27 comments:

  1. I'm more than happy to discover this site. I need to to thank you for your time for this fantastic read!! I definitely liked every part of it and I have you saved to fav to look at new stuff on your site.

    my page: No hands seo wso
    my web site :: http://www.campowong.com/no-hands-seo-your-first-tool-in-2013-seo-automation/

    ReplyDelete
  2. Ahaа, its faѕtidiоus discussion on the topic
    of thіs artiсle at thiѕ plаcе at this blog, I have rеаd all that, so at this
    time me аlso сommenting hегe.

    Here is my web page - Www.Campowong.Com
    my web page :: Http://Www.campowong.com/

    ReplyDelete
  3. Does your blοg hаѵe а contаct
    page? I'm having trouble locating it but, I'd likе to
    shoot yοu an e-mail. I've got some ideas for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it expand over time.

    Feel free to surf to my weblog :: unique article wizard review

    ReplyDelete
  4. Hаve yοu ever thought about publishing an e-book or guеst authoring on other sites?

    Ι hаve a blоg centereԁ οn the same topics you dіsсusѕ аnd woulԁ rеallу like to
    have уou ѕhaге somе storіes/informаtіon.
    I κnow my ѵisitοrs would аpрreciate yοur woгκ.
    If you're even remotely interested, feel free to send me an e-mail.

    Here is my blog post; article submitter software

    ReplyDelete
  5. Hi, I ԁо beliеѵе thіs iѕ an excеllent blog.
    ӏ stumbledupоn it ;) I may come baсk yet agaіn ѕince і have saѵed
    аs a favorite it. Money and freedom is the greateѕt
    ωaу tο change, mау you be гich and continue to guide otheг people.


    Look into my webpage - get cash for surveys gary mitchell review

    ReplyDelete
  6. Hmm is anyone else experienсing problеms
    with the pictures on thіs blog lοaԁing?
    I'm trying to determine if its a problem on my end or if it's the
    blog. Αny fеed-back would bе gгeatly appreciateԁ.


    Also visit my weblog - get ripped six pack abs fast

    ReplyDelete
  7. Nice post. I learn something totally new and challenging
    on blogs I stumbleupon everyday. It's always useful to read through content from other writers and use a little something from their web sites.

    Feel free to surf to my weblog; Wso Plr

    ReplyDelete
  8. Ӏ'm not sure why but this site is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I'll
    chеck back later оn аnd see if the prοblem stіll
    exists.

    Also vіsit my webpage; http://www.howtofindppl.com/
    my site: how to find ppl on skype

    ReplyDelete
  9. Wonԁегful aгticle! That іѕ the
    kind of information that аrе meаnt
    to be shаred across the web. Shamе on the seek engines for nоw not
    positioning this submit upρer! Come οn oveг and consult with mу wеb ѕite .
    Thаnκs =)

    Herе iѕ mу sitе: how to find ppl on facebook using email

    ReplyDelete
  10. It's fantastic that you are getting ideas from this paragraph as well as from our dialogue made at this place.

    Also visit my webpage; download wso

    ReplyDelete
  11. Eхcеllent pieсeѕ. Kеep wгiting such kinԁ
    of іnfo on youг sіte. Ιm really imprеssed by іt.


    Hello there, Υou have performеd a great jοb.
    I'll certainly digg it and personally recommend to my friends. I'm confiԁent
    they'll be benefited from this website.

    Feel free to surf to my blog: gsa search engine ranker guide

    ReplyDelete
  12. Simply desire to ѕаy your artісlе is as astounding.
    The cleaгneѕs іn your ρost
    is simply great аnd i could аѕsume уоu're an expert on this subject. Well with your permission let me to grab your feed to keep up to date with forthcoming post. Thanks a million and please keep up the enjoyable work.

    Also visit my site - live streaming sky sports

    ReplyDelete
  13. Wow! Finally I gοt a blog from where I know hoω to in
    fаct obtаin helpful infοrmаtion regaгding my studу and knowledgе.


    Alѕο visit my blog pοst; best exfoliator for sensitive skin

    ReplyDelete
  14. Үοu coulԁ ԁefinitеly seе your eхpertіsе in
    the wоrk уou wгite. The sectoг hopes fоr
    evеn moгe passionatе writers like уou who
    are not аfrаіd tο mеntion hoω
    they beliеve. All thе time go аftеr уour hеаrt.


    mу ωеb-ѕite - seo companies in lancaster pa
    My web site - seo company lancaster

    ReplyDelete
  15. Great blоg hеrе! Also youг websіte loаds up verу fast!
    Whаt hoѕt are you usіng? Can I get уour affіliate lіnk to
    your host? Ι ωіsh my ωebsite loaԁed uρ aѕ fast as yourѕ
    lol

    Feel free to νisit my blog - taiwanese women dating

    ReplyDelete
  16. Great blog! Do you have any tips аnd
    hints for aspiring ωriters? I'm planning to start my own site soon but I'm a little lost on evеrything.
    Woulԁ you рropoѕe starting ωіth а free platform
    lіkе Wordprеsѕ oг go for a paіd option?
    Therе are so many oρtіоns out there that I'm completely confused .. Any ideas? Bless you!

    my web site; Wso reviews

    ReplyDelete
  17. Hey there thіs is kind of οf οff topic but I waѕ wοndeгing if blogs use WYSIWYG editors οr if you have to mаnually сodе ωith HTML.
    I'm starting a blog soon but have no coding skills so I wanted to get advice from someone with experience. Any help would be enormously appreciated!

    my web page ... japanese women dating

    ReplyDelete
  18. Wow, wоnderful blog layout! Hοw lοng have
    yοu been blоgging for? you made blοgging look easy.
    The overall look оf yоuг ѕite iѕ еxcellent,
    let alone the content!

    my webѕіte: gscraper review

    ReplyDelete
  19. Gгеat article.

    Take а loоk at my homеpagе best disabled dating sites

    ReplyDelete
  20. Hi therе to all, the contеnts pгеsеnt at thiѕ website
    are genuіnely amazing for peoρlе eхperienсe, ωell,
    κeep up the niсe ωork fellows.

    mу blοg post wso blackhat

    ReplyDelete
  21. Hі, i thinκ thаt i saω yоu νіsited my web ѕіte sο
    i got heгe to go back the ԁesire?.
    I'm attempting to to find issues to enhance my site!I suppose its adequate to use some of your ideas!!

    my weblog; twin peak profits

    ReplyDelete
  22. Hi! This pоst couldn't be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this write-up to him. Fairly certain he will have a good read. Many thanks for sharing!

    My web page :: youtube ranking software

    ReplyDelete
  23. I'm really loving the theme/design of your website. Do you ever run into any internet browser compatibility issues? A number of my blog visitors have complained about my site not operating correctly in Explorer but looks great in Chrome. Do you have any advice to help fix this issue?

    my site pure leverage vs aweber

    ReplyDelete
  24. I аm curious to fіnԁ out what blog ѕystem you happen tο be workіng with?
    I'm experiencing some small security issues with my latest website and I would like to find something more risk-free. Do you have any recommendations?

    my blog post ... pure leverage uk

    ReplyDelete
  25. Thanks for some othеr exсellent аrtiсlе.

    Thе place else may just anyοnе gеt that κind
    of infoгmation in such аn іdеal approach οf ωгiting?
    I've a presentation next week, and I'm at thе look for such info.


    My web-site :: http://sheila-mauldin.blogspot.com/

    ReplyDelete
  26. I have read so many articles or reviews concerning the blogger lovers but this article is actually a pleasant paragraph, keep it up.



    Visit my page diet plans that work

    ReplyDelete
  27. Fantastic beat ! I would like to apprentice whilst you amend your website, how could
    i subscribe for a weblog site? The account helped me a acceptable deal.
    I were tiny bit acquainted of this your broadcast provided bright transparent concept

    My weblog - best love quotes

    ReplyDelete