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