Greg Boehnlein ( )
Fri, 20 Jun 1997 20:27:56 -0400

At 09:37 AM 6/12/97 -0700, you wrote:
>PLEASE do a backup (dump) regularly just before your nightly
>backup (yes, you are doing nightly backups, aren't you?).
>The easiset way to do this is to have SQL Executive run a task
>every night before you bakup. Create a dump device in Enterprise
>manager to a drive that is getting backed up. Then, for the task,
>select SQL command and use:
>DUMP Database Emerald to Dump_DEV With INIT
>where dump_dev is the dump service you created.

We are doing this nightly. However, I AM finding that based on our call
volumes we tend to fill the transaction log quite a bit. This causes an
insane number of complaints in the error logs etc..

So.. I'm wondering if there is an automated method to allow dumping of
transaction log?