{"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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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_90057\"  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;disablekb=0&#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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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_70249\"  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;disablekb=0&#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 class=\"wp-block-paragraph\">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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_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},"jetpack_post_was_ever_published":false},"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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Preston de Guise\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Data Protection Hub | All things Data Protection\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Basics \u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub\" \/>\n\t\t<meta property=\"og:description\" content=\"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2021-05-02T21:28:20+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2021-05-02T21:28:23+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Basics \u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#article\",\"name\":\"Basics \\u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub\",\"headline\":\"Basics \\u2013 Avamar and Microsoft SQL Server Recoveries\",\"author\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/author\\\/nsrd\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/bigStock-Database.jpg\",\"width\":900,\"height\":900,\"caption\":\"bigstock Database\"},\"datePublished\":\"2021-05-03T07:28:20+10:00\",\"dateModified\":\"2021-05-03T07:28:23+10:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#webpage\"},\"articleSection\":\"Avamar, Databases, avamar, flat-file recovery, flat-file restore, Microsoft SQL Server, SQL Server, table-level recovery, table-level restore\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nsrd.info\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/category\\\/databases\\\/#listItem\",\"name\":\"Databases\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/category\\\/databases\\\/#listItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/category\\\/databases\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#listItem\",\"name\":\"Basics \\u2013 Avamar and Microsoft SQL Server Recoveries\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#listItem\",\"position\":3,\"name\":\"Basics \\u2013 Avamar and Microsoft SQL Server Recoveries\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/category\\\/databases\\\/#listItem\",\"name\":\"Databases\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/#person\",\"name\":\"Preston de Guise\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d274b0939f505e2f4b85a111bdf61ff0fafc11f17dcd667d16a47d0a3de63a1d?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Preston de Guise\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/author\\\/nsrd\\\/#author\",\"url\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/author\\\/nsrd\\\/\",\"name\":\"Preston de Guise\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d274b0939f505e2f4b85a111bdf61ff0fafc11f17dcd667d16a47d0a3de63a1d?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Preston de Guise\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#webpage\",\"url\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/\",\"name\":\"Basics \\u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub\",\"description\":\"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/author\\\/nsrd\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/author\\\/nsrd\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/bigStock-Database.jpg\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#mainImage\",\"width\":900,\"height\":900,\"caption\":\"bigstock Database\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/2021\\\/05\\\/03\\\/basics-avamar-and-microsoft-sql-server-recoveries\\\/#mainImage\"},\"datePublished\":\"2021-05-03T07:28:20+10:00\",\"dateModified\":\"2021-05-03T07:28:23+10:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/\",\"name\":\"Data Protection Hub\",\"description\":\"All things Data Protection\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/nsrd.info\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub","description":"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.","canonical_url":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#article","name":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub","headline":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries","author":{"@id":"https:\/\/nsrd.info\/blog\/author\/nsrd\/#author"},"publisher":{"@id":"https:\/\/nsrd.info\/blog\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/nsrd.info\/blog\/wp-content\/uploads\/2017\/07\/bigStock-Database.jpg","width":900,"height":900,"caption":"bigstock Database"},"datePublished":"2021-05-03T07:28:20+10:00","dateModified":"2021-05-03T07:28:23+10:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#webpage"},"isPartOf":{"@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#webpage"},"articleSection":"Avamar, Databases, avamar, flat-file recovery, flat-file restore, Microsoft SQL Server, SQL Server, table-level recovery, table-level restore"},{"@type":"BreadcrumbList","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/nsrd.info\/blog#listItem","position":1,"name":"Home","item":"https:\/\/nsrd.info\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/nsrd.info\/blog\/category\/databases\/#listItem","name":"Databases"}},{"@type":"ListItem","@id":"https:\/\/nsrd.info\/blog\/category\/databases\/#listItem","position":2,"name":"Databases","item":"https:\/\/nsrd.info\/blog\/category\/databases\/","nextItem":{"@type":"ListItem","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#listItem","name":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries"},"previousItem":{"@type":"ListItem","@id":"https:\/\/nsrd.info\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#listItem","position":3,"name":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries","previousItem":{"@type":"ListItem","@id":"https:\/\/nsrd.info\/blog\/category\/databases\/#listItem","name":"Databases"}}]},{"@type":"Person","@id":"https:\/\/nsrd.info\/blog\/#person","name":"Preston de Guise","image":{"@type":"ImageObject","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/d274b0939f505e2f4b85a111bdf61ff0fafc11f17dcd667d16a47d0a3de63a1d?s=96&d=mm&r=g","width":96,"height":96,"caption":"Preston de Guise"}},{"@type":"Person","@id":"https:\/\/nsrd.info\/blog\/author\/nsrd\/#author","url":"https:\/\/nsrd.info\/blog\/author\/nsrd\/","name":"Preston de Guise","image":{"@type":"ImageObject","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/d274b0939f505e2f4b85a111bdf61ff0fafc11f17dcd667d16a47d0a3de63a1d?s=96&d=mm&r=g","width":96,"height":96,"caption":"Preston de Guise"}},{"@type":"WebPage","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#webpage","url":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/","name":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub","description":"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/nsrd.info\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#breadcrumblist"},"author":{"@id":"https:\/\/nsrd.info\/blog\/author\/nsrd\/#author"},"creator":{"@id":"https:\/\/nsrd.info\/blog\/author\/nsrd\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/nsrd.info\/blog\/wp-content\/uploads\/2017\/07\/bigStock-Database.jpg","@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#mainImage","width":900,"height":900,"caption":"bigstock Database"},"primaryImageOfPage":{"@id":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/#mainImage"},"datePublished":"2021-05-03T07:28:20+10:00","dateModified":"2021-05-03T07:28:23+10:00"},{"@type":"WebSite","@id":"https:\/\/nsrd.info\/blog\/#website","url":"https:\/\/nsrd.info\/blog\/","name":"Data Protection Hub","description":"All things Data Protection","inLanguage":"en-US","publisher":{"@id":"https:\/\/nsrd.info\/blog\/#person"}}]},"og:locale":"en_US","og:site_name":"Data Protection Hub | All things Data Protection","og:type":"article","og:title":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub","og:description":"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.","og:url":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/","article:published_time":"2021-05-02T21:28:20+00:00","article:modified_time":"2021-05-02T21:28:23+00:00","twitter:card":"summary","twitter:title":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries | Data Protection Hub","twitter:description":"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery."},"aioseo_meta_data":{"post_id":"10337","title":null,"description":"Avamar can do a couple of cool Microsoft SQL Server recoveries: pulling back a database backup as flat files, or even table-level recovery.","keywords":[],"keyphrases":{"focus":{"keyphrase":"Avamar","score":88,"analysis":{"keyphraseInTitle":{"title":"Focus Keyphrase in SEO title","description":"Focus Keyphrase found in SEO title.","score":9,"maxScore":9,"error":0},"keyphraseInDescription":{"title":"Focus keyphrase in meta description","description":"Focus keyphrase found in meta description.","score":9,"maxScore":9,"error":0},"keyphraseInURL":{"title":"Focus Keyphrase in URL","description":"Focus Keyphrase used in the URL.","score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"title":"Focus keyphrase in introduction","description":"Your Focus keyphrase appears in the first paragraph. Well done!","score":9,"maxScore":9,"error":0},"keyphraseInSubHeadings":{"title":"Focus Keyphrase in Subheadings","description":"Use your focus keyphrase more in your H2 and H3 subheadings.","score":3,"maxScore":9,"error":1},"keyphraseLength":{"title":"Focus keyphrase length","description":"Good job!","score":9,"maxScore":9,"error":0,"length":1},"keyphraseInImageAlt":[]}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":{"locations":{"business":{"name":"","businessType":"","image":"","areaServed":"","urls":{"website":"","aboutPage":"","contactPage":""},"address":{"streetLine1":"","streetLine2":"","zipCode":"","city":"","state":"","country":"","addressFormat":"#streetLineOne\n#streetLineTwo\n#city, #state #zipCode"},"contact":{"phone":"","email":"","fax":""},"ids":{"vat":"","tax":"","chamberOfCommerce":""},"payment":{"priceRange":"","currenciesAccepted":"","methods":""}}},"openingHours":{"useDefaults":true,"show":true,"alwaysOpen":false,"use24hFormat":false,"timezone":"","labels":{"closed":"","alwaysOpen":""},"days":{"monday":{"open24h":false,"closed":false,"openTime":"09:00","closeTime":"17:00"},"tuesday":{"open24h":false,"closed":false,"openTime":"09:00","closeTime":"17:00"},"wednesday":{"open24h":false,"closed":false,"openTime":"09:00","closeTime":"17:00"},"thursday":{"open24h":false,"closed":false,"openTime":"09:00","closeTime":"17:00"},"friday":{"open24h":false,"closed":false,"openTime":"09:00","closeTime":"17:00"},"saturday":{"open24h":false,"closed":false,"openTime":"09:00","closeTime":"17:00"},"sunday":{"open24h":false,"closed":false,"openTime":"09:00","closeTime":"17:00"}}}},"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-05-02 05:44:14","updated":"2025-07-20 05:44:43","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/nsrd.info\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/nsrd.info\/blog\/category\/databases\/\" title=\"Databases\">Databases<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tBasics \u2013 Avamar and Microsoft SQL Server Recoveries\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/nsrd.info\/blog"},{"label":"Databases","link":"https:\/\/nsrd.info\/blog\/category\/databases\/"},{"label":"Basics \u2013 Avamar and Microsoft SQL Server Recoveries","link":"https:\/\/nsrd.info\/blog\/2021\/05\/03\/basics-avamar-and-microsoft-sql-server-recoveries\/"}],"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}]}}