{"id":3256,"date":"2011-03-11T04:30:00","date_gmt":"2011-03-11T04:30:00","guid":{"rendered":"https:\/\/test.simple-talk.com\/uncategorized\/restoring-databases\/"},"modified":"2016-07-28T10:50:20","modified_gmt":"2016-07-28T10:50:20","slug":"restoring-databases","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/restoring-databases\/","title":{"rendered":"Restoring Databases"},"content":{"rendered":"<p>I like the way Mike Walsh phrased it: <a href=\"http:\/\/www.straightpathsql.com\/archives\/2011\/02\/can-you-restore-sql-server-sqlu\/\">You&#8217;re Only As Good as Your Ability To Restore<\/a>. Ain&#8217;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&#8217;t restored the database, what do you have? You don&#8217;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&#8217;d need a system with as much space as production. unless.. Ever heard of SQL Virtual Restore? <a href=\"http:\/\/www.red-gate.com\/products\/dba\/sql-virtual-restore\/?utm_source=simpletalk&amp;utm_medium=weblink&amp;utm_content=grantrestore&amp;utm_campaign=sqlvirtualrestore\">Check it out<\/a>. With this, you answer Mike&#8217;s questions and validate your backups without having to have twice the amount of space. That&#8217;s a win, and we all know, winning is better than losing.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I like the way Mike Walsh phrased it: You&#8217;re Only As Good as Your Ability To Restore. Ain&#8217;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&#8217;t restored the database, what do you have?&#8230;&hellip;<\/p>\n","protected":false},"author":221792,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[],"class_list":["post-3256","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/3256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/221792"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=3256"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/3256\/revisions"}],"predecessor-version":[{"id":25221,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/3256\/revisions\/25221"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=3256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=3256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=3256"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=3256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}