ADSM-L

Re: dbb & dbsnapshots

2005-01-17 17:53:31
Subject: Re: dbb & dbsnapshots
From: Steve Harris <Steve_Harris AT HEALTH.QLD.GOV DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 18 Jan 2005 08:52:23 +1000
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.
***********************************************************************************

<Prev in Thread] Current Thread [Next in Thread>