ADSM-L

Re: dbb & dbsnapshots

2005-01-17 15:48:05
Subject: Re: dbb & dbsnapshots
From: Paul Fielding <paul.fielding AT SHAW DOT CA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 17 Jan 2005 13:32:47 -0700
I actually do the opposite - I send snapshots offsite and leave DBBs
onsite - the reason being that you can roll forward recovery logs on a dbb
but not on a dbs - if you lose your db due to non-disaster reasons, it is
quite possible that you may still have the recovery logs and can roll
forward.    In the event of a disaster where you need to restore from
offsite, chances are higher that your entire site was destroyed and you
won't have logs to roll forward.

The only downside to this approach is that you *must* make sure you are
consistent about using type=dbs with all your 'q drmedia' and 'move drmedia'
commands to ensure that you are handling the correct tapes for offsite
movement...

regards,

Paul

----- Original Message -----
From: "Joni Moyer" <joni.moyer AT HIGHMARK DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Monday, January 17, 2005 1:21 PM
Subject: [ADSM-L] dbb & dbsnapshots


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
********************************

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