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
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