Hi Jim,
Why not buy a cheap NAS box on 250GB and keep that NAS Device always mounted in 
the filesystem and do the DB backups to that?
So even if the RAID breaks down you still have an on-site backup of your DB for 
fast recover.

But you still need to bring back the offsite tapes for all user data.

Thanks
Christian

-----Ursprungligt meddelande-----
Från: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] För Jim 
Zajkowski
Skickat: den 21 april 2006 17:57
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: Database backups

Hi folks,

I'm considering a database backup strategy something like this:

   a. Every day write incremental backups to a FILE devclass on a
      remote server.

   b. Every Friday write a full backup to the same remote FILE
      devclass.

   c. We take our copypool tapes out on Friday as well, so I would
      additionally generate a db snapshot to tape and remove it from
      the library at the same time.

Does this seem to pass muster?  My reasoning for the FILE backups is that
I'd like to have a db backup in case the RAID/filesystem holding my online
DB breaks, but I'm uninterested in buying a number of LTO2 tapes just to
write a 24 gigabyte file to them.

--Jim