Thanks Paul! One other question: do you do a DRM Plan? If so, how do you change it to include dbsnapshots instead of dbbackups? Thanks!
******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ******************************** "Paul Fielding" <[EMAIL PROTECTED] AW.CA> To Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: dbb & dbsnapshots 01/17/2005 03:32 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 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" <[EMAIL PROTECTED]> To: <ADSM-L@VM.MARIST.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 > [EMAIL PROTECTED] > ********************************