{"id":860,"date":"2019-11-21T00:00:00","date_gmt":"2019-11-21T08:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files"},"modified":"2025-06-29T09:47:34","modified_gmt":"2025-06-29T16:47:34","slug":"azure-backup-support-for-sql-server-2019-and-restore-as-files","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/","title":{"rendered":"Azure Backup support for SQL Server 2019 and restore as files"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data. This is especially true if you are running the SQL Server in the cloud to leverage the benefits of dynamic scale and don&#8217;t want to continue using the legacy backup methods that are tedious, infrastructure-heavy, and difficult to scale.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We are excited to share native backup for SQL Server 2019 running in Azure Virtual Machine. This is a key addition to the general availability of <a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\" target=\"_blank\" rel=\"noopener\">Azure Backup for SQL Server Virtual Machine<\/a>, announced earlier this year.&nbsp; Azure Backup is a <strong>zero-infrastructure<\/strong> solution that protects standalone SQL Server and <strong>SQL AlwaysOn<\/strong> configurations in Azure Virtual Machine without the need to deploy and manage any backup infrastructure. While it offers <strong>long-term retention<\/strong> and <strong>central monitoring<\/strong> capabilities to help IT admins govern and meet their compliance requirements, it lets SQL Admin continue to exercise the power of <strong>self-service<\/strong> backup and restore for operational recoveries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In addition to this, we are also sharing Azure Backup general availability for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">\u00a0<a href=\"https:\/\/cloudblogs.microsoft.com\/sqlserver\/2019\/06\/20\/announcing-native-backup-for-sql-server-2008-end-of-support-in-azure\/\" target=\"_blank\" rel=\"noopener\">SQL Server 2008 and 2008 R2 migrating to Azure as SQL Server running in virtual machines<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">SQL Server running on <strong>Windows 2019<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp\" alt=\"Backup SQL server in Azure VM\" style=\"border-radius:0px\" title=\"Backup SQL server in Azure VM\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"restore-as-files\">Restore as files:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Adding to the list of enhancements is the key capability of <strong>restore as Files<\/strong>, now restore anywhere by recovering the backed-up data as <strong>.bak <\/strong>files. Move these backup files across subscriptions, regions, or even to on-premises SQL Servers and trigger database restore wherever you want. Besides aiding cross-subscription and cross-region restore scenarios, this feature helps users stay compliant by giving them greater control over storing and recovering backup data to any destination of their choice.<img loading=\"lazy\" decoding=\"async\" title=\"Restore options for SQL server\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/b856f616-1dba-4d2d-bb09-f1a50750866b.webp\" alt=\"Restore options for SQL server\" width=\"1024\" height=\"576\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"getting-started\">Getting started:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Under the <strong>restore<\/strong> operation, you will see a newly introduced option of <strong>restore as files<\/strong>. Specify the destination server (this server should be SQL Server Virtual Machine registered to the vault) and path on that server. The service will dump all the .bak files specific to the recovery point you have chosen to this path. Typically, a network share path or path of a mounted Azure File share when specified as the destination enables easier access to these files by other machines in the same network or with the same Azure File share mounted on them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once the restore operation is completed, you can move these files to any machine across subscriptions or locations and restore them as a database using SQL Server Management Studio. <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/backup\/restore-sql-database-azure-vm#restore-as-files\" target=\"_blank\" rel=\"noopener\">Learn more<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/34dba673-0ee6-489a-813e-18f179530219.webp\" alt=\"Restore as files\" style=\"border-radius:0px\" title=\"Restore as files\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"additional-resources\">Additional resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">Watch the getting started <a href=\"https:\/\/www.youtube.com\/watch?v=wmbANpHos_E&amp;t=52s\" target=\"_blank\" rel=\"noopener\">video<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Want more details about this feature? Review the <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/backup\/backup-azure-sql-database\" target=\"_blank\" rel=\"noopener\">Azure Backup for SQL Server documentation<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">Get the Azure Backup <a href=\"https:\/\/azure.microsoft.com\/en-us\/pricing\/details\/backup\/\" target=\"_blank\" rel=\"noopener\">pricing <\/a>details for this feature.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1467],"tags":[],"audience":[3057,3053,3056],"content-type":[],"product":[1548,1455],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-860","post","type-post","status-publish","format-standard","hentry","category-compute","audience-data-professionals","audience-it-decision-makers","audience-it-implementors","product-azure-backup","product-virtual-machines","review-flag-anywh-1680286580-635","review-flag-gener-1680286584-335","review-flag-lever-1680286579-649"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure Backup support for SQL Server 2019 and restore as files | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Backup support for SQL Server 2019 and restore as files | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-21T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-29T16:47:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Azure Backup support for SQL Server 2019 and restore as files\",\"datePublished\":\"2019-11-21T08:00:00+00:00\",\"dateModified\":\"2025-06-29T16:47:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/\"},\"wordCount\":451,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp\",\"articleSection\":[\"Compute\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/\",\"name\":\"Azure Backup support for SQL Server 2019 and restore as files | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp\",\"datePublished\":\"2019-11-21T08:00:00+00:00\",\"dateModified\":\"2025-06-29T16:47:34+00:00\",\"description\":\"As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compute\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/compute\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Azure Backup support for SQL Server 2019 and restore as files\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure Backup support for SQL Server 2019 and restore as files | Microsoft Azure Blog","description":"As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/","og_locale":"en_US","og_type":"article","og_title":"Azure Backup support for SQL Server 2019 and restore as files | Microsoft Azure Blog","og_description":"As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-11-21T08:00:00+00:00","article_modified_time":"2025-06-29T16:47:34+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Azure Backup support for SQL Server 2019 and restore as files","datePublished":"2019-11-21T08:00:00+00:00","dateModified":"2025-06-29T16:47:34+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/"},"wordCount":451,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp","articleSection":["Compute"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/","name":"Azure Backup support for SQL Server 2019 and restore as files | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp","datePublished":"2019-11-21T08:00:00+00:00","dateModified":"2025-06-29T16:47:34+00:00","description":"As SQL Server 2019 continues to push the boundaries of availability, performance, and data intelligence, a centrally managed, enterprise-scale backup solution is imperative to ensure the protection of all that data.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/eda6a05e-75d3-47ed-88c2-0ae27e75ec3e.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-support-for-sql-server-2019-and-restore-as-files\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Compute","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/compute\/"},{"@type":"ListItem","position":3,"name":"Azure Backup support for SQL Server 2019 and restore as files"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=860"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/860\/revisions"}],"predecessor-version":[{"id":44185,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/860\/revisions\/44185"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=860"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=860"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=860"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=860"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=860"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=860"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}