{"id":26641,"date":"2019-03-18T09:00:12","date_gmt":"2019-03-18T16:00:12","guid":{"rendered":""},"modified":"2024-01-29T12:03:19","modified_gmt":"2024-01-29T20:03:19","slug":"enterprise-scale-backup-for-sql-server-databases","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/","title":{"rendered":"Enterprise-scale Backup for SQL Server Databases"},"content":{"rendered":"\n<p>More and more organizations are moving to the cloud to leverage the key benefits of agility and reduced overall cost. It\u2019s likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure: <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-technical-overview\">SQL Azure Database<\/a>, <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-managed-instance\">SQL Managed Instance<\/a> or <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/virtual-machines\/sql-server\/\">SQL Server on Azure Virtual Machine (VM<\/a>).<\/p>\n\n\n\n<p>For the first two implementation types, backups are automatically managed by Azure internally. However, a significant number of customers choose to lift and shift SQL Server from on-premises physical or virtual environments to Azure VM to reduce friction and lower migration costs or risks. Should you choose to do so, you\u2019ll still need to own and manage the backups for the SQL Server VM. Although you moved your SQL Server infrastructure from on-premises to Azure, the good news is that you don\u2019t have to move your backup infrastructure to cloud, thanks to Azure Backup!<\/p>\n\n\n\n<p>Azure Backup fulfills the cloud promise of a <strong>cost-effective, elastic-scale, zero-infrastructure<\/strong> solution that eliminates the need to deploy or manage backup infrastructure, agents, or storage accounts. While it offers long term retention and central management capabilities to help IT admins govern and meet their compliance requirements, it lets SQL Admin continue to exercise the power of self-service backup and restore for operational recoveries. It uses the <strong>native SQL APIs<\/strong> to leverage the inherent backup capabilities to yield high fidelity backups and restores for standalone SQL Server and SQL AlwaysOn configurations in the Azure VMs.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-1024x576.webp\" alt=\"Back up SQL Server in Azure VM using Azure Backup.\" class=\"wp-image-26656 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases.webp 2560w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-300x169.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-1024x576.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-768x432.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-1536x864.webp 1536w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-2048x1152.webp 2048w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-330x186.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-800x450.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-400x225.webp 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-235x132.webp 235w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-960x540.webp 960w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases.png 2560w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-300x169.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-1024x576.png 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-768x432.png 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-1536x864.png 1536w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-2048x1152.png 2048w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-330x186.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-800x450.png 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-400x225.png 400w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-235x132.png 235w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/SQL-Server-databases-960x540.png 960w\"><\/figure>\n\n\n\n<p>The solution empowers enterprises to protect their SQL databases by providing a simple and consistent user experience and by giving the capability of management at scale. The following is a list of its <strong>key value propositions:<\/strong>&nbsp;<strong>&nbsp;<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"simple\">Simple:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Get started in no time since there is no need to deploy any backup servers and agents and schedule backups to meet your recovery point objective (RPO)&nbsp;needs as low as 15 minutes, in a matter of a few clicks.<\/li>\n\n\n\n<li>Complete self-service restores to a point in time up to a second in one click, without having to manually apply a chain of logs over differential and full backups. No more long drawn out and error-prone manual restore procedures!<\/li>\n\n\n\n<li>Be assured of optimized storage with built-in backup storage lifecycle management that prunes the recovery points as per your RPO and retention policy.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"scalable\">Scalable:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Get <em>freedom from provisioning or managing storage,<\/em> as the solution automatically takes care of it internally.<\/li>\n\n\n\n<li>Create <em>centrally managed backup policies<\/em> with support for <em>long-term retention<\/em> spanning years.<\/li>\n\n\n\n<li>Scale protection to newly added databases automatically via the <em>auto-protection <\/em>capability, thus managing a dynamic environment efficiently.<\/li>\n\n\n\n<li><em>Monitor backups <\/em>across servers from a<em> single pane of glass<\/em> and receive consolidated alerts and emails based on events that matter.<\/li>\n<\/ul>\n\n\n\n<p>The built-in security features of Azure Backup safeguard the backups against malicious attacks, corruptions, and deletions. You can back up <em>encrypted databases<\/em>, and secure backups with <em>built-in encryption at rest <\/em>while controlling backup &amp; restore operations with <em>Role-Based Access Control<\/em>. With geo-redundant storage, you never lose your backup data, even if the entire primary region comes down, your backups are safely stored in the secondary region.<\/p>\n\n\n\n<p>And all of these capabilities come at a reduced<em> total cost of ownership<\/em> due to elimination of all the backup infrastructure and no overhead of managing at scale because of streamlined operations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"get-started\">Get Started:<\/h2>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\" target=\"_blank\" rel=\"noreferrer noopener\">Watch the video<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"customer-feedback\">Customer feedback:<\/h2>\n\n\n\n<p>It\u2019s been a few months since we announced the pubic preview, and most of our customers see a lot of value in the solution and particularly insist on how simple and fast their backup and restore operations have become:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote blockquote is-layout-flow wp-block-quote blockquote-is-layout-flow\">\n<p><em>\u201cOur experience with Azure SQL Server Backup has been fantastic. It\u2019s a solution you can put in place in a couple of minutes and not have to worry about it. To restore DBs, we don\u2019t have to deal with rolling logs and only have to choose a date and time. It gives us great peace of mind to know the data is safely stored in the Recovery Services Vaults with our other protected items.\u201d<\/em><\/p>\n\n\n\n<p>&#8211; Steven Hayes, Principal Architect, Acuity Brands Lighting, Inc<\/p>\n\n\n\n<p><em>\u201cWe have been using Azure Backup for SQL Server for the past few months and have found it simple to use and easy to set up. The backup and restore operations are performant and reliable as well as easy to monitor. We plan to continue using it in the future.&#8221;<\/em><\/p>\n\n\n\n<p>&#8211; Celica E. Candido, Cloud Operations Analyst, Willis Towers Watson<\/p>\n<\/blockquote>\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>Check out the <a href=\"https:\/\/aka.ms\/ga-announcement-azblog\">Azure backup for SQL VM GA<\/a> announcement on the Azure blog channel.<\/li>\n\n\n\n<li>See different&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/virtual-machines\/windows\/sql\/virtual-machines-windows-sql-backup-recovery#decision-matrix\">SQL backup options <\/a>from Microsoft and choose the right solution based on your requirements.<\/li>\n\n\n\n<li>Want more details about this feature? Check out the&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/backup\/backup-azure-sql-database\">Azure Backup for SQL Server documentation<\/a>.<\/li>\n\n\n\n<li>Get the&nbsp;<a href=\"https:\/\/azure.microsoft.com\/en-au\/pricing\/details\/backup\/\">pricing <\/a>details for this feature.<\/li>\n\n\n\n<li>Need help? Reach out to the <a href=\"https:\/\/social.msdn.microsoft.com\/forums\/azure\/en-US\/home?forum=windowsazureonlinebackup\">Azure Backup forum<\/a> for support or browse the&nbsp;<a href=\"https:\/\/docs.microsoft.com\/azure\/backup\/\">Azure Backup documentation<\/a>.<\/li>\n\n\n\n<li>Tell us how we can&nbsp;<a href=\"http:\/\/feedback.azure.com\/forums\/258995-azure-backup\">improve Azure Backup <\/a>by contributing new ideas and voting up existing ones.<\/li>\n\n\n\n<li>If you are new to&nbsp;<a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/backup\/\">Azure Backup<\/a>, sign up for a&nbsp;<a href=\"https:\/\/azure.microsoft.com\/en-us\/pricing\/free-trial\/\">free Azure trial subscription<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>More and more organizations are moving to the cloud to leverage the key benefits of agility and reduced overall cost. It\u2019s likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure: SQL Azure Database, SQL Managed Instance or SQL Server on Azure Virtual Machine (VM).<\/p>\n","protected":false},"author":5562,"featured_media":26758,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2415],"content-type":[2448],"topic":[],"coauthors":[2599],"class_list":["post-26641","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-sql","product-sql-server-on-azure-vms","content-type-updates","review-flag-1593580414-58","review-flag-free-1593619513-128","review-flag-ga-1593580755-860","review-flag-lever-1593580264-545","review-flag-never-1593580314-843","review-flag-new-1593580247-437","review-flag-pubic-1593580301-590","review-flag-vm-1593580806-223","review-flag-watch-1593580721-697"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Enterprise-scale Backup for SQL Server Databases - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enterprise-scale Backup for SQL Server Databases - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"More and more organizations are moving to the cloud to leverage the key benefits of agility and reduced overall cost. It\u2019s likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure: SQL Azure Database, SQL Managed Instance or SQL Server on Azure Virtual Machine (VM).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-18T16:00:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T20:03:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Swati Sachdeva\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Swati Sachdeva\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/swati-sachdeva\/\",\"@type\":\"Person\",\"@name\":\"Swati Sachdeva\"}],\"headline\":\"Enterprise-scale Backup for SQL Server Databases\",\"datePublished\":\"2019-03-18T16:00:12+00:00\",\"dateModified\":\"2024-01-29T20:03:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\"},\"wordCount\":861,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\",\"name\":\"Enterprise-scale Backup for SQL Server Databases - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg\",\"datePublished\":\"2019-03-18T16:00:12+00:00\",\"dateModified\":\"2024-01-29T20:03:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg\",\"width\":1280,\"height\":720,\"caption\":\"a screenshot of a cell phone\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Enterprise-scale Backup for SQL Server Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Enterprise-scale Backup for SQL Server Databases - Microsoft SQL Server Blog","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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/","og_locale":"en_US","og_type":"article","og_title":"Enterprise-scale Backup for SQL Server Databases - Microsoft SQL Server Blog","og_description":"More and more organizations are moving to the cloud to leverage the key benefits of agility and reduced overall cost. It\u2019s likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure: SQL Azure Database, SQL Managed Instance or SQL Server on Azure Virtual Machine (VM).","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2019-03-18T16:00:12+00:00","article_modified_time":"2024-01-29T20:03:19+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg","type":"image\/jpeg"}],"author":"Swati Sachdeva","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Swati Sachdeva","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/swati-sachdeva\/","@type":"Person","@name":"Swati Sachdeva"}],"headline":"Enterprise-scale Backup for SQL Server Databases","datePublished":"2019-03-18T16:00:12+00:00","dateModified":"2024-01-29T20:03:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/"},"wordCount":861,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/","name":"Enterprise-scale Backup for SQL Server Databases - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg","datePublished":"2019-03-18T16:00:12+00:00","dateModified":"2024-01-29T20:03:19+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/03\/enterprise-scale-backup-for-sql.jpg","width":1280,"height":720,"caption":"a screenshot of a cell phone"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/enterprise-scale-backup-for-sql-server-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Enterprise-scale Backup for SQL Server Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/26641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/5562"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=26641"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/26641\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/26758"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=26641"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=26641"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=26641"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=26641"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=26641"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=26641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}