ADSM-L

Database backups

2006-04-21 11:59:27
Subject: Database backups
From: Jim Zajkowski <jamesez AT UMICH DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 21 Apr 2006 11:57:16 -0400
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

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