Noob; Backups to Stupid Proof SQL Server 2005

  • I just picked up a book on the 70-431 SQL server 2005 MCP exam.

    My question is how do I back up the SQL Server configurations (plus any other configurations like database specific configs)

    To back up files, I know I can shut down the service and do a file copy to back up the DB files. I can also use SMSS and ...

    BACKUP DATABASE TO DEVICE

    In Summary, I'd like to back everything up before and after each chapter. I know how to back up DB files, but have no clue on how to back up configurations.

  • Most database specific configurations are either included with a database backup or in a backup of the master database. If you want to save really everything you should also backup your registry, because that's where settings like dafault database folder, log folder, network settings etc. is stored.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • Actually, to back up the database and all its data you do not have to stop the service.   There are a couple of approaches that you can take to accomplish a backup. 

    First, if you write a backup script in T-SQL then schedule that script to run then you will have mechanism where that the backup occurs regularly.  To really have redundancy you could schedule a file backup of the script as well from the OS backup capability. 

    You can also create a backup task in enterprise manager under maintainence plans and then schedule that task.  This tool has the ability to script and schedule that task as well.

  • Thanks for everyone's reply.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply