We usually DUMP (via the db maint wiz) Emerald, Master & MSDB db's.
The pubs and tempdb are just samples
Is that better?
jeff
----------
From: Dale E. Reed Jr. [SMTP:daler@iea.com]
Sent: Saturday, July 26, 1997 8:47 PM
To: emerald@emerald.iea.com
Subject: Re: HELP! Lost my server!
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)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com---------------------------------------------------------- Emerald Mailing List listserver@emerald.iea.com