while 1. + 2. should work fine, your optin 3. DOES NOT produce a backup
that is of any value!!!!
The best way is to dump the database (as you suggested in 1.) to a tape
or to disk. Here's how I do my manual backup if I have to (automatic
backup and check is done every night with SQL EXEC)
; truncate the transaction log
dump transaction Emerald with truncate_only
go
; dump database to file IMMEDIATELY (modify UNC according
; to your needs, remember that SQL must not be running as
; system user for this dump to work to another machine's drives)
dump database Emerald to disk = '\\sangpdc\temp\emerald9706100.dat' with
init, stats=5
-
Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
* Microsoft Solution Provider * Intel Systems Integrator *
>----------
>Von: Albert Churba[SMTP:Albert@dialisdn.com]
>Gesendet: Donnerstag, 12. Juni 1997 15:36
>An: 'emerald@emerald.iea.com'
>Betreff: RE: EMERALD.DAT Backup
>
>Mark,
>
>There are few options I know about:
>
>1) Put a tape drive in the SQL server and use the Back-Up function in SQL.
>
>2) Use a third party software like BackupEXEC with the SQL module. This
>solution will run about $1,100.00. Ouch!
>
>3) Use a batch file (or .cmd) to stop the service, backup the .DAT file, and
>then restart the service. I do something similar with Exchange Server once a
>week to back-up the total structure.
>
>Hope this helps.
>
>Regards,
>Albert
>
>
>----------
>From: Mark A. Knight[SMTP:RadAdmin@Express-Connect.Net]
>Reply To: emerald@emerald.iea.com
>Sent: Thursday, June 12, 1997 3:56 AM
>To: Emerald Mail-List (E-mail)
>Subject: EMERALD.DAT Backup
>
>Hello everyone,
>
>I have a question that is probably basic SQL, but, I don't know the answer so
>I'm asking! I do daily backups of my servers, but, important files, like
>EMERALD.DAT are always skipped because they are open/in use.
>
>How does one go about backing up the Emerald database on a regular basis? I
>recently got bit by not having a good backup and I don't EVER want that to
>happen again!
>
>Thanks in advance.
>
>NT 4.0 (Build 1381-SP3) - MS SQL Server 6.5 - RadiusNT V 1.16.60
> Emerald Client 2.1.8 - Emerald Admin 2.1.0 - Serv-U V2.2 32 Bit
> MailSite Version 1.2.2 - NAS Ascend MAX 4000
> Mark A. Knight - PC Express, Inc
> RadAdmin@Express-Connect.Net
>
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>