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