Howard can correct me if I'm wrong, but I believe he was talking about
backing up directly to disk, and then copying the backup to another
location (SAN, tape, CD-ROM, whatever). I'm sure Howard didn't mean to
imply that your only backup should be on the same server as your
database. So make sure you have a copy of your backup somewhere else.
However, it is handy if a copy of that backup resides on the same
server. Should you have a problem, you don't need to run and find the
tape you copied it to and restore from tape. Your recovery times are
greatly improved if you have it available on disk, but don't rely on
that in case of a total failure.
HTH,
Brian
--
===================================================================
Brian Peasland
dba_at_remove_spam.peasland.com
Remove the "remove_spam." from the email address to email me.
"I can give it to you cheap, quick, and good. Now pick two out of
the three"
Received on Wed Nov 05 2003 - 11:28:13 CST
