Re: RadiusNT and SQL back-up question

Peter D. Mayer ( (no email) )
Thu, 30 Jul 1998 18:42:13 -0400

The best way we've found to do this is to do an SQL Backup of your database
each night just before the machine backup runs.
1)In Enterprise Manager, go to Tools>Database Backup/Restore.
2)Under Database Device click New.
3)Pick a name, and make sure "Disk Backup Device" is selected.
4)Select the database you want backed up, and click Entire Database,
Initialize Device, and No Expiration date.
5)Then click on your newly created Backup Device and click schedule. Leave
the volume label blank.
6)Select recurring, and select Daily, every 1 days, occurs once at 12:00AM
(or just before your backup starts).

Then even though it doesn't backup your main database, it will still backup
the backup device. Then if you need to restore, just restore the backup
device from tape and use the restore utility.

Just a suggestion,
Peter D. Mayer
NetWalk Tech Support
dmayer@netwalk.com

-----Original Message-----
From: Postman Account <postman@cp-tel.net>
To: radiusnt@iea-software.com <radiusnt@iea-software.com>
Date: Thursday, July 30, 1998 3:56 PM
Subject: RadiusNT and SQL back-up question

>Recently, we upsized our RadiusNT database to MS SQL.
>
>I just tried to back-up our SQL server... and I noticed
>that the Radius database files were all skipped because
>they were in use.

>
>Any suggestions as to how to properly back-up the
>whole server... including the Radius database files?
>
>Please reply... thanks in advance.