stsadm.exe



I would like to clarify a few points about stsadm.exe before using it as my only backup. This newsgroup seems to be the best place to do so.

1) Does stsadm.exe backup all files, documents, pictures, settings, pages, etc. for the top-level site and all subsites?

2)When restoring, is it true that you only need to run stsadm.exe with the restore switch and it will recreate the site for you, along with all of the permissions? Will it recreate the actual databases as well?

3) What if you are recovering to an entirely new server in an entirely new location with a different infrastructure. For example, your production environment is IIS/WSS on one server, SQL Server on another. If you have to grab your backups and run to a temporary location where you only have one server to run IIS and SQL Server, what is the process? Would you need to have WSS installed and ready, with the content and configuration databases set through Central Administration? I'm thinking purely disaster recovery here. With the current regulatory environment in the U.S., I need the capability to quickly recover everything in a less than optimal situation.

It's just hard to believe that it rolls everything into one file. I've made a few backups, but haven't gone about restoring them yet because I don't have a place to try. It's just a little scary because the .dat file created by stsadm.exe is so small, I can't believe that everything is in there. But maybe it is. I just keep thinking that maybe I should copy off the folders from IIS and SQL Server as well or do a database backup from SQL Server.

Thanks for any help,
Aaron
.



Relevant Pages

  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... Deletes old backup files ... In the job history for 'Nightly backup' is that job listed as passed ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (microsoft.public.sqlserver.tools)
  • Re: Backing Up Mirrored database
    ... Tibor Karaszi, SQL Server MVP ... > all databases; and both run successfully without any issues. ... "Attempt to backup but receives an error message from the engine so the job fails"? ...
    (microsoft.public.sqlserver.tools)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
  • Re: Scheduling a Daily Backup of a SQL Database
    ... history for the job step usually has some more details. ... as if they are only set to SIMPLE you just need to backup the database. ... have found out how to backup ypur databases, you should be sure that you are ... SQL Server 2008 Standard for its database. ...
    (microsoft.public.sqlserver.server)
  • Re: SBS2003, NTBackup-Fehler
    ... Falls das Problem noch verhandeln ist,werde ich vorschalgen nächste Schritte durchzuführen. ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)

Loading