You should do the same thing for the "master" database (using another
backup device). I'd let the backup (diskdump) of "master" run before
backing up "Emerald". I have my "master" db get backed up at 3:00am, then
"Emerald" at 3:15am. If you already created the schedule for your Emerald
backup, you can change the time if you need to by going into SQL Enterprise
Manager --> Server pull-down menu --> Scheduled Tasks. Double-click on
your Emerald backup task and change the time in there.
When I run a tape-backup, it backs up the diskdumps. Periodically, I stop
MSSQL Server, and copy the contents of \mssql\data to some other area,
restart MSSQL, then run a tape backup--that way I get a backup of the
actual database files.
> -----Original Message-----
> From: Postman Account <email@example.com>
> >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.