-----Original Message-----
From: PowerNet [mailto:psc5@powersupply.net]
Sent: Monday, October 02, 2000 11:15
To: emerald@iea-software.com
Subject: Re: [Emerald] Backup Database/Device with SQL 6.5
One thing that may be happening that happened to us.
When you create your backup routine, you need to make sure initialize device
is checked. This will overwrite yesterdays info. Otherwise it will append
every day and your disk will quickly fill up.
We have a primary and backup database and run the following routines every
night.
Backup primary
Transfer primary to backup
Backup on the backup server
Seems to work great for us.
Our info on the backup is always a max of 24 hours old.
John
*********** REPLY SEPARATOR ***********
On 10/2/2000 at 11:04 AM keitenmiller@hughestech.net wrote:
>Back when we had Emerald originally set up, IEA created a backup device for
>us.
>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?
>OR
>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
>drive)?
>
>Any ideas, suggestions or help would be appreciated.
>Thanks,
>Ken Eitenmiller
>Hughes Business Technologies
>keitenmiller@hughestech.net
>www.hughestech.net
>
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart