We have a db on a server that has two hard drives: one has c: while the other is partitioned into d/e: (yeah, I’d like another disk but that is not happening anytime soon)
c: has the OS
d: has data and logs
e: has db/log backups
c: & e: get backed up to tape each night.
Now I think that if d/e: dies, then we are all the way back to the last tape.
So here?s what I think might be a better solution:
c: Logs & log backups
d: Data
e: db backups
If c: fails we can backup the db, set up a new logfile and carry on.
If d/e: fails we can pull the db off the tape and apply the logs off c:
Is this really a better idea?
