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.
JOhn :}
> Jeff Tuttle wrote:
> >
> > We usually bu Emerald, Master & MSDB db's. The pubs and tempdb are
just
> > 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. (daler@iea.com)
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers!
608.742.1601 & 6980 2800 New Pinery Road, Suite 10
http://www.palacenet.net/ Portage, WI 53901
http://www.microt.com/
--- __o
--- _-\<,_ FASTEST SERVICE IN TOWN
--- (_)/ (_)
----------