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 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply