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