[Emerald] Backup Database/Device with SQL 6.5

Kenneth Gustav Eitenmiller Jr ( keitenmiller@hughestech.net )
Mon, 2 Oct 2000 11:04:46 -0500

Back when we had Emerald originally set up, IEA created a backup device for
At a later time I added it to the task scheduler.
A small problem showed up, It ate all of our disk space.

Now I am trying to make this right... But what is the right way?

Do I create a full database backup everyday?
Do I create a full database backup once a week with a log backup every day
in between?

Using SQL 6.5 I have created a backup device called EmeraldDatabaseBackup...
I can make the damn thing make a full database backup everyday... but then
again, it will fill my drive quickly...
Is there a way to make it write over backups that are 7 days old?
How do I need to set the whole thing up where it will make a full database
backup every Sunday, backup the log Monday thru Saturday, and the write over
the backups every third week(So I only have 2 weeks of backup stored on the

Any ideas, suggestions or help would be appreciated.
Ken Eitenmiller
Hughes Business Technologies

For more information about this list (including removal) go to: