I am trying to figure out a IT company policy for backups, and here is what I have come up with.
We are using Veritas Backup Exec 10d, on a standalone server with a terabyte of space and lt0 tape drive.
We have daily (mon-thur) differential tapes set 1 and 2. Set 1 runs odd months and set 2 runs even months. After a month, the set is taken off site and stored, until next month when it returns. Upon arrival, it is fully formatted and used again.
On Fridays, I run a full backup. The last friday backup is archived as a monthly.
M T W T F
D1 D1 D1 D1 W1
D1 D1 D1 D1 W2
D1 D1 D1 D1 W3
D1 D1 D1 D1 W4
M T W T F
D2 D2 D2 D2 W1
D2 D2 D2 D2 W2
D2 D2 D2 D2 W3
D2 D2 D2 D2 W4
So around 9PM, we have a script which dumps our SQL databases from servers to a local folder on that particular server. From there was thinking to copy that SQL dump file to a folder on the backupserver, which the backup jobs incorporate.
When backups run, they run to the backup server, and then a duplicate backup job runs immediately to copy it to tape.
This is pretty much what I have thought about so far, any help on changes, more efficient use, etc would be great. The confusion comes when trying to manually delete the SQL dumps on the backupserver folder, so that every days don't get backed up to every newer tape.