I do nightly dumps of the Emerald db and Weekly dumps of the Master db AND
try to at least 2 - 3 times a month, shut down SQL * copy all the data to
another drive for backup.
> Jeff Tuttle wrote:
> > We usually bu Emerald, Master & MSDB db's. The pubs and tempdb are
> > samples.
> You do NOT backup those. You need to do a dump, and backup the dump.
> Even if you are backing up all your *.dat files, you would have to
> stop your SQL Server to do that. If you just make a dump, you can do
> it on the fly w/out any outage. I use SQL Executive to dump the
> databases about 30 mins before the nightly backup kicks off.
> Dale E. Reed Jr. (firstname.lastname@example.org)
John C. Lange, Sr. PALACE dot NET, INC.
email@example.com MICRO-TECH Computers!
608.742.1601 & 6980 2800 New Pinery Road, Suite 10
http://www.palacenet.net/ Portage, WI 53901
--- _-\<,_ FASTEST SERVICE IN TOWN
--- (_)/ (_)