none
Difference between site backup,restore and content db backup restore RRS feed

  • Question

  • Hi,

    Please clarify me what is the difference between site back up & restore and content db backup/restore. they both differ in what ways since contents appear to be same


    sree

    Wednesday, May 23, 2012 6:57 AM

Answers

  • Hi there,

    If I understand your question, I suspect you have a single site collection you are looking to restore so the result would appear to be the same, but to clarify:

    1. Site backup and restore (stsadm -backup or the powershell equivalent) would be for backing up a single site collection/restoring it from a content database

    2. Content DB Backup Restore would be by restoring the database in SQL and then attaching it to a web application and a content database could have many site collections in it (and you'd need to make sure you have any appropriate managed paths in place as well)

    3. Though you didn't ask, stsadm -export would be if you wanted to export/import a single web from a site collection.  Though use this option with caution as site columns/content types inherited from a web/subsite above won't come with it, etc.

    Hope that helps.
    Sean


    Sean Wallbridge, SharePoint MVP | Victoria, BC | On The Web: http://www.itgroove.net | Blog: http://blog.brainlitter.com

    Wednesday, May 23, 2012 7:00 AM

All replies

  • Hi there,

    If I understand your question, I suspect you have a single site collection you are looking to restore so the result would appear to be the same, but to clarify:

    1. Site backup and restore (stsadm -backup or the powershell equivalent) would be for backing up a single site collection/restoring it from a content database

    2. Content DB Backup Restore would be by restoring the database in SQL and then attaching it to a web application and a content database could have many site collections in it (and you'd need to make sure you have any appropriate managed paths in place as well)

    3. Though you didn't ask, stsadm -export would be if you wanted to export/import a single web from a site collection.  Though use this option with caution as site columns/content types inherited from a web/subsite above won't come with it, etc.

    Hope that helps.
    Sean


    Sean Wallbridge, SharePoint MVP | Victoria, BC | On The Web: http://www.itgroove.net | Blog: http://blog.brainlitter.com

    Wednesday, May 23, 2012 7:00 AM
  • Content DB can have more than one site collection.Content DB is a collection of features, sites, webs, site users and other related information and thus its different from site back up.

    Further refer below link which gives you backup/restore plan information http://technet.microsoft.com/en-us/library/cc261687.aspx


    Regards, Dharnendra Shah, MCTS,MCPD - Sharepoint 2010 Application Development Blog: http://ds-sharepoint2010blogs.blogspot.in/ Email: shahdg2003@gmail.com

    Wednesday, May 23, 2012 7:08 AM
  • Ok..do we have any difference such as say i have out of box webpart and am doing site back up restore and content back up restore

    sree

    Wednesday, May 23, 2012 7:12 AM
  • Ok..do we have any difference such as say i have out of box webpart and am doing site back up restore and content back up restore

    sree


    If you are backing up the whole site collection and it is staying with the same web application/farm, the web parts should continue to function as they are installed into the farm as a solution or were in the site collection/gallery itself. If you are moving it to a different web application, you will want to ensure the web part (if farm based) is deployed to that web application

    Sean Wallbridge, SharePoint MVP | Victoria, BC | On The Web: http://www.itgroove.net | Blog: http://blog.brainlitter.com

    Wednesday, May 23, 2012 7:16 AM
  • oh fine.

     content db can have one or more site collections and i am talking about single site collection so site back up restore and content db backup restore will function in the same way.


    sree

    Wednesday, May 23, 2012 7:27 AM
  • oh fine.

     content db can have one or more site collections and i am talking about single site collection so site back up restore and content db backup restore will function in the same way.


    sree


    Yep. If you have a content database with a single site collection, you could effectively achieve the same results with either method. I like the content database method as it is smoother, more elegant and bullet proof but both methods should work.

    Sean Wallbridge, SharePoint MVP | Victoria, BC | On The Web: http://www.itgroove.net | Blog: http://blog.brainlitter.com

    Wednesday, May 23, 2012 7:31 AM
  • There may be several site collections in the SAME database. But you can run the backup command only for one site collection at a time.

    I used both methods. And I like the SQL Content database backup restore better. When I want to move a web application I re-create it on another farm and restore the Content DB's to new servers. Then I add content db's to the new web application in Central Administration. it is faster than stsadm backup options but you may encounter with synchronization errors in WFE server logs. But you'll need to re-do some configuration on the new central administration.( I had no harm from that errors during the upgrades or whatever)

    Stsadm backup-restore may be the cleaner way but I always rely on SQL backups.

    Of course in both options you should always backup the content you have deployed to the server directories additionally, you'll need to restore them if you are migrating to another server which does not have them installed.


    ceren



    • Edited by ova c Wednesday, May 23, 2012 7:38 AM
    Wednesday, May 23, 2012 7:32 AM
  • Thank you sean.

    How do you mention content db method of restoring is smooth? please eloborate


    sree

    Wednesday, May 23, 2012 7:35 AM
  • 1. Site backup and restore (stsadm -backup or the powershell equivalent) would be for backing up a single site collection/restoring it from a content database

    If I use site backup/restore and move content database to a new server, MOSS to a new server, do I need to backup and restore old content database to new SQL server seperatly before I perform site restoring.

    In other words, dose site backup actually backup the content database? the xxx.bak file is same as SQL server backup file?

    Tuesday, March 4, 2014 11:47 PM
  • 1. Site backup and restore (stsadm -backup or the powershell equivalent) would be for backing up a single site collection/restoring it from a content database

    If I use site backup/restore and move content database to a new server, MOSS to a new server, do I need to backup and restore old content database to new SQL server seperatly before I perform site restoring.

    In other words, dose site backup actually backup the content database? the xxx.bak file is same as SQL server backup file?

    SPSite backups are all of the data that is needed to re-create that site again in a new content database.

    It effectively creates a copy of all the site's data from the content database and leaves it in a format that SharePoint can insert again into another database. That means that you would not have to copy the content database from farm A to farm B, instead you would backup the site on farm A and restore on farm B. You can do the same thing with SQL but that's another story.

    The exported files from Backup-SPSite are not the same as a SQL backup. Those are a different format and would contain ALL the sites within that content database, which can be thousands of sites.

    Tuesday, March 4, 2014 11:54 PM
  • Thank you Alex,

    My DBA already had content db backed up and restored on the new SQL server, and I have a new MOSS server setup, but is empty, in this case, what do I need to do to restore a new site?

    by the way, it's single site collection per content db.

    Thanks again!

    • Edited by Lily M Wednesday, March 5, 2014 12:15 AM
    Wednesday, March 5, 2014 12:08 AM
  • It's a long story, this technet article describes the backup and recovery process, which is fairly similar to your situation by the sounds of things.

    http://technet.microsoft.com/en-us/library/ee663477(v=office.14).aspx

    If you need more help i'd suggest creating a new thread as this one isn't particulary suitable.

    Wednesday, March 5, 2014 9:37 AM