July 6, 2006 at 2:09 pm
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
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.
July 7, 2006 at 12:35 am
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]
July 8, 2006 at 8:48 am
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.
July 8, 2006 at 2:43 pm
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