Re: [RadiusNT]

Dale E. Reed Jr. ( (no email) )
Tue, 07 Sep 1999 09:34:31 -0700

Brian Kerr wrote:
>
> We use backup exec on the nt sql server that has the database. It does a
> complete backup from 10pm to 8am, and at certain times there are odbc
> timeout errors from radius. You suggest backing up in a different manner?
> If so please advise. The database is rather large. Around 600 Megs.

I'm sure BE SQL module is great, but I don't like the concept of
anything but SQL Server itself doing the backup/restore. If you get
into a bind and need MS to help you, they are not going to support
a backup in BE format. However, if you can restore a dump from tape,
then they CAN help you restore that dump, etc.

I recommend scheduling a dump of your DB about 1/2 hour before your
backup is scheduled to go, and then just backing up the dump of your
DB (its just a file containing the data). The dump usually only
takes a couple of minutes for a DB that size, and then the backup
does not interact with your SQL Server directly, and resolves the
issues you describe.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart