locked
Sharepoint backup with third party software, good or bad? RRS feed

  • Question

  • My question really revolves around something that recently happened and I'm trying to figure out the best way to improve this situation.  We are currently running Sharepoint Enterprise 2007 and SQL 2008 on windows 2008 server datacenter x64 (on seperate servers of corse) and for our backup solution we are using Symantec Backup Exec.  Recently, last week, we lost data on both our Sharepoint and SQL servers and I had been backing these up via the Symantec Backup Exec addons for both SQL and Sharepoint.  I would stand up brand new servers named the same thing and basically restore the database back to SQL and the site would come back up after an iisreset /noforce.  However this process took me forever to get it to this state as I had a lot of failed restores, took a few days to get it straight.  I know there's some better way to do this like with the STSADM command and the administration site using .bak files.  I was also reading on restore that you lose some things like alerts that were tagged to a specific site and other things like that.  Is this really the best way to backup the database or am I better using my third party program that I use to backup the rest of my servers?  I'm mainly trying to go for how long and how complete the restore process takes, any suggestions?

    Saturday, November 14, 2009 7:06 PM

Answers

All replies

  • Using stsadm you can use the following commands for backup/restore

    stsadm -o backup -url http://yourserver/ -filename c:\xyz.dat
    stsadm -o restore -url http://yourtarget/ -filename c:\xyz.dat -overwrite

    A detailed article about backup/restore

    http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=46

    Another article

    http://dhunter-thinkingoutaloud.blogspot.com/2007/07/stsadm-import-export.html
    Thanks,
    A.m.a.L
    Dot Net Goodies
    Don't hate the hacker, hate the code
    Saturday, November 14, 2009 7:21 PM
  • Hello,

    actually I have never used or worked with the third party tools for SharePoint backup/restore but I can suggest you that always better to use stsadm command line tool or the UI i.e. centtral administaion in SharePoint.
    actually you can use one good utility on codeplex for this purpose :- http://sp2007backuputility.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=15295

    Warm Regards, Bhushan Gawale
    Saturday, November 14, 2009 8:59 PM
  • I have personal experience doing restores of SharePoint 2007 Enterprise with BackupExec, DPM, and stsadm. DPM is by far the best. I have had a lot of problems with BackupExec...mostly that I get a lot of errors and it takes way too long. DPM is much better. The problem with stsadm and Central Administration, of couse, is that there is no built in scheduling functionality.

    I was recently at the Chicago SharePoint 2010 Roadshow and the clear recommendation from the MVPs there was to use DPM or AvePoint in both SharePoint 2007 and SharePoint 2010.

    Don't get disillusioned with third party tools because of your experience with BackupExec. It is, in my opinion, an inferior tool.

    Another note: making sure your databases are always below 100GB will make the restore process a lot less painless when you have to do it.
    DougTheCoder www.sharepointdoug.com
    Sunday, November 15, 2009 3:21 AM