Hi Joni, I'm currently planning a new environment - pilot in a month - and am going to do a snapshot twice daily but with only 1 day retention and twice daily incrementals across the wire to an offsite server, with a weekly full on Sunday morning. Retention is 4 days, but even if they were all fulls I'd use 4 days.
The reason for this is that realistically we are never going to go back that far. We just need to recover, worst case, on a Tuesday from an error on a Friday on a weekend with a public holiday. Retention of 4 days will cover that. Making it longer wastes tapes, and of course you can't reuse your copypool volumes for the same length of time as you keep your DB, so that you can recover if you ever did restore. In my case, with small libraries and aiming for no manual intervention, I need that space back. Mind you, I still need to get this past management. Regards Steve Steve Harris Queensland Health, Brisbane Australia >>> [EMAIL PROTECTED] 18/01/2005 6:21:03 >>> Hello All! I just thought I would ask what everyone's standards are concerning database backups and database snapshots. My thoughts on this are to keep 14 days worth of database backups which will be sent offsite and to allow DRM to delete old dbb. I was then thinking of taking dbsnapshots once/day for onsite database backup restore in case of an immediate onsite emergency and keeping 7 dbsnapshots and deleting them by running del volh type=dbsnapshot todate=today-7. Any discussions/suggestions on this topic are appreciated. Thank you! ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ******************************** *********************************************************************************** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. ***********************************************************************************
