eric (8/13/2009)
Thanks a lot Jeffrey. I'll have to read that again tomorrow morning and look into it. I like the idea of keeping more than one full backup at a time.Until now it's been an issue because of our daily disk to tape backups which pick up the sql server backup files for storage outside.
Your solution would pretty much fix all my problems AND give me the possibility to return to a 2 days old backup with losing 3 hours restoring a 20G backup file from tape.
Thanks again.
Glad I could help - now, the other thing you might want to look into is something like Hyperbac or Litespeed to compress and speed up your backups/restores. Just something we do on our systems that helps out a lot.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs