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
>>> joni.moyer AT HIGHMARK DOT COM 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
joni.moyer AT highmark DOT com
********************************
***********************************************************************************
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.
***********************************************************************************
|