I just realized a typo in my previous message.  the flag I was referring to
should be 'source=dbs', rather than 'type=dbs'.

I do use a DRM planfile - to have it understand your tape layout correctly
if sending snapshots offsite, you should run it with the 'prepare
source=dbs' flag, as well.  This should be run *after* tapes have been
removed from the library, so that the planfile it creates knows that the
tapes are offsite.    The planfile can then be either copied to a floppy and
sent offsite with the tapes, or you could write a script or batch file to
email the planfile to an offsite email address....

regards,

Paul

----- Original Message -----
From: "Joni Moyer" <joni.moyer AT HIGHMARK DOT COM>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Tuesday, January 18, 2005 5:03 AM
Subject: Re: [ADSM-L] dbb & dbsnapshots

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



            "Paul Fielding"
            <paul.fielding@SH
            AW.CA>                                                     To
            Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT 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" <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
********************************