Restoring Databases

Posted by Grant Fritchey on Simple Talk See other posts from Simple Talk or by Grant Fritchey
Published on Fri, 11 Mar 2011 04:30:00 GMT Indexed on 2011/03/11 16:16 UTC
Read the original article Hit count: 330

Filed under:

I like the way Mike Walsh phrased it: You're Only As Good as Your Ability To Restore. Ain't it the truth. You may be taking backups, incrementals, and log backups of your databases. You may have DBCC in place, and all that fun stuff. But if you haven't restored the database, what do you have? You don't know. The trick is, restoring databases takes up a heck of a lot of space on your servers. To test all your productions backups, you'd need a system with as much space as production. unless.. Ever heard of SQL Virtual Restore? Check it out. With this, you answer Mike's questions and validate your backups without having to have twice the amount of space. That's a win, and we all know, winning is better than losing.

© Simple Talk or respective owner