{"id":10337,"date":"2021-05-03T07:28:20","date_gmt":"2021-05-02T21:28:20","guid":{"rendered":"https:\/\/nsrd.info\/blog\/?p=10337"},"modified":"2021-05-03T07:28:23","modified_gmt":"2021-05-02T21:28:23","slug":"basics-avamar-and-microsoft-sql-server-recoveries","status":"publish","type":"post","link":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/","title":{"rendered":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries"},"content":{"rendered":"\n<p>I&#8217;ve had a need in the last few days to run up some tests using Avamar to recover SQL Server databases. And so I figured with the lab environment configured, it&#8217;s a good opportunity to record some demos.<\/p>\n\n\n\n<p>I&#8217;ll cover off the standard database recoveries later, since I&#8217;ve spent all weekend working and ran out of steam. But, I do have two special case recoveries that I think are worthwhile seeing in action.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server Table-Level Recoveries<\/h2>\n\n\n\n<p>In the video below, I step through the process of recovering a single database table from Microsoft SQL Server. This is a really useful technique in Avamar, and too easily forgotten about.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"epyt-video-wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_65548\"  width=\"688\" height=\"387\"  data-origwidth=\"688\" data-origheight=\"387\"  data-relstop=\"1\" src=\"https:\/\/www.youtube.com\/embed\/-eU34Sk13Mg?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=0&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;\" class=\"__youtube_prefs__  epyt-is-override  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div>\n<\/div><figcaption><strong><em><a href=\"https:\/\/youtu.be\/-eU34Sk13Mg\" target=\"_blank\" rel=\"noreferrer noopener\">Avamar Table-Level Recovery from SQL Server Database<\/a><\/em><\/strong><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server Database Flat File Recoveries<\/h2>\n\n\n\n<p>Normally when you&#8217;re recovering SQL Server databases in Avamar, you&#8217;ll recover them as a database into an active SQL Server. But sometimes it&#8217;s useful to recover them first as flat backup files that SQL Server can read. That way, you can do pre-processing, or copy them somewhere else entirely.<\/p>\n\n\n\n<p>In the video below, I show you how that process works.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"epyt-video-wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_87389\"  width=\"688\" height=\"387\"  data-origwidth=\"688\" data-origheight=\"387\"  data-relstop=\"1\" src=\"https:\/\/www.youtube.com\/embed\/uiFQTwX0rrw?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=0&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;\" class=\"__youtube_prefs__  epyt-is-override  no-lazyload\" title=\"YouTube player\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div>\n<\/div><figcaption><strong><em><a href=\"https:\/\/youtu.be\/uiFQTwX0rrw\" target=\"_blank\" rel=\"noreferrer noopener\">Avamar Recovery of SQL Server Database to Flat Files<\/a><\/em><\/strong><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Before You Go&#8230;<\/h2>\n\n\n\n<p>Thanks for checking out the videos. Before you go, don&#8217;t forget that the second edition of <strong><a href=\"https:\/\/www.routledge.com\/Data-Protection-Ensuring-Data-Availability\/Guise\/p\/book\/9780367256777\" target=\"_blank\" rel=\"noreferrer noopener\">Data Protection: Ensuring Data Availability<\/a><\/strong> has a plethora of information about running a data protection environment. Not just the technology either \u2013&nbsp;processes, operational considerations and best practices all appear in the book. (And if you&#8217;d prefer an electronic copy, it&#8217;s <strong><a href=\"https:\/\/books.apple.com\/au\/book\/data-protection\/id1565190675\" target=\"_blank\" rel=\"noreferrer noopener\">now available in the Apple Book store<\/a><\/strong>, too!)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve had a need in the last few days to run up some tests using Avamar to recover SQL Server&hellip;<\/p>\n","protected":false},"author":1,"featured_media":6331,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1154,9],"tags":[134,1614,1615,1611,1367,1612,1613],"class_list":["post-10337","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-avamar-2","category-databases","tag-avamar","tag-flat-file-recovery","tag-flat-file-restore","tag-microsoft-sql-server","tag-sql-server","tag-table-level-recovery","tag-table-level-restore"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/nsrd.info\/blog\/wp-content\/uploads\/2017\/07\/bigStock-Database.jpg","jetpack_shortlink":"https:\/\/wp.me\/pKpIN-2GJ","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/10337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/comments?post=10337"}],"version-history":[{"count":3,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/10337\/revisions"}],"predecessor-version":[{"id":10341,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/posts\/10337\/revisions\/10341"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/media\/6331"}],"wp:attachment":[{"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/media?parent=10337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/categories?post=10337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nsrd.info\/blog\/wp-json\/wp\/v2\/tags?post=10337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}