Re: EMERALD.DAT Backup

Greg Boehnlein ( damin@nacs.net )
Fri, 20 Jun 1997 20:27:56 -0400

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Tom Bilan: "Re: Emerald=DSN Error "DSN is not installed...you must install"
Next message: Greg Boehnlein: "Re: CC AVS Re-post"

At 09:37 AM 6/12/97 -0700, you wrote:
>PLEASE READ THIS!
>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?

Previous message: Tom Bilan: "Re: Emerald=DSN Error "DSN is not installed...you must install"
Next message: Greg Boehnlein: "Re: CC AVS Re-post"