March 13, 2009 at 8:37 am
In my testing with BackupExec, several years ago, I found myself in the same boat as Lynn Pettis was saying. The tapes are too slow and tie up SQL Server resources for too long. If what Homebrew01 says is also true, that's another reason tape is unacceptable, because I can never be sure, in a DR situation where I will have to restore the DB. The DR company may not supply me with exact volumes to mirror what I had in Production, and in lots of cases I use a backup from Prod to restore to Dev for testing or troubleshooting purposes, and the volumes definitely don't match Prod there.
These reasons convinced me to only do SQL backups to disk, local disk if possible, then copy the backups to a SAN/NAS for tape backup, or have the tape backup pull the backup files directly from the server.
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
March 13, 2009 at 8:47 am
the speed of the tapes depends on the tech being used. new LTO-4 tapes are around 1TB per hour per drive.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply