SharePoint 2007 : different backup and restore approach RRS feed

  • Question

  • Hi All,

    Im currently working on content migration in SharePoint, I would like to know the different between the stsadm backup & restore and database attach migration.

    and when to use each of the method?

    thank you in advanced.

    Monday, January 30, 2012 4:12 AM

All replies

  • stsadm -o backup helps you take a backup of specific site collections and portals making .bak file which can be restored with stsadm -o restore command. This gives you control to migrate from site collection level like choose what you need to migrate


    the database attach will carry all the portals and site collections residing in database and if you are planing an upgrade you will have to use the command stsadm -o attachcontentdb command.

    There is no way to say which one is better until you can give us a little more information on your enviroment and your plans.

    - Nidhi
    Monday, January 30, 2012 7:23 AM
  • Hi Nidhi,

    thank you for your reply, I was trying to migrate content database from SharePoint 2007 to another SharePoint farm.

    the following is the steps I did so far:

    1) backup content database from SQL Server Management Studio

    2) create a new database in another farm, restore & overwrite it with the backup content database

    3) create a new web application, detach the default content database

    4) run stsadm -o addcontentdb which make use of the restored content database

    5) create new site collection

    the operation was successful, however I not able to see any content load from the backup content database, instead of the site collection I created.

    "View All Site Content" and "Site Settings" was hitting errors stated "File not found...".

    please help if there is any mistake on I did from the steps.

    Monday, January 30, 2012 9:05 AM
  • when you add a content database the sites should show up you need not create a site collection.

    I think you are at the wrong site.

    go to CA > application management > site collection list

    navigate to the created web application and choose the site collection. check url on the right side description box, hit that url thats where your site is.

    - Nidhi
    Monday, January 30, 2012 9:27 AM
  • when I browse to the web application I created, e.g url = http://webapp:9999, there is nothing on the page. any idea?
    Monday, January 30, 2012 9:40 AM

    did you attach the database to that http://webapp:9999

    go to that restored database from sql management studio expand databases do you see anything under dbo.sites



    - Nidhi
    Monday, January 30, 2012 11:05 AM
  • Hi,

    Go to CA-->Application Management.Under SharePoint Web Application Mangement,click on Content databases.

    Choose the right web application(http://webapp:9999) and you should be able to see the list of content database along with Number of sites.

    to see the previous site collection, you shold not create any new site collections.


    Monday, January 30, 2012 7:44 PM
  • I view the web application in CA, the content database was correct (from the backup content database).

    but there is 0 number of sites, any idea?

    I not able to browse the page and it hit http 404 error.

    Tuesday, January 31, 2012 5:48 AM