{"id":89142,"date":"2019-03-18T16:33:16","date_gmt":"2019-03-18T16:33:16","guid":{"rendered":"https:\/\/news.microsoft.com\/?p=431842"},"modified":"2019-03-18T16:33:16","modified_gmt":"2019-03-18T16:33:16","slug":"now-available-azure-backup-for-sql-server-virtual-machines-the-simple-modern-way-to-do-backup-in-the-cloud","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2019\/03\/18\/now-available-azure-backup-for-sql-server-virtual-machines-the-simple-modern-way-to-do-backup-in-the-cloud\/","title":{"rendered":"Now available: Azure Backup for SQL Server Virtual Machines \u2013 the simple, modern way to do backup in the cloud"},"content":{"rendered":"<p>How do you back up your SQL Servers today? You could be using backup software that require you to manage backup servers, agents, and storage, or you could be writing elaborate custom scripts which need you to manage the backups on each server individually. With the modernization of IT infrastructure and the world rapidly moving to the cloud, do you want to continue using the legacy backup methods that are tedious, infrastructure-heavy, and difficult to scale? <strong>Azure Backup for <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/virtual-machines\/sql-server\/\">SQL Server Virtual Machines<\/a> <\/strong>(VMs) is the modern way of doing backup in cloud, and we are excited to announce that it is now generally available! It is an <strong>enterprise scale<\/strong>, <strong>zero-infrastructure<\/strong> solution that eliminates the need to deploy and manage backup infrastructure while providing a simple and consistent experience to <strong>centrally manage and monitor the backups<\/strong> on standalone SQL instances and <strong>Always On Availability Groups<\/strong>.<\/p>\n<p><a href=\"https:\/\/azurecomcdn.azureedge.net\/mediahandler\/acomblog\/media\/Default\/blog\/39dccdb5-edbf-4cb5-a13f-5267ae74caa0.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"Azure Backup for SQL Server running in Azure Virtual Machines\" border=\"0\" height=\"454\" src=\"http:\/\/www.sickgaming.net\/blog\/wp-content\/uploads\/2019\/03\/now-available-azure-backup-for-sql-server-virtual-machines-the-simple-modern-way-to-do-backup-in-the-cloud.png\" title=\"Azure Backup for SQL Server running in Azure Virtual Machines\" width=\"807\"><\/a><\/p>\n<p>Built into Azure, the solution combines the core cloud promises of <em>simplicity<\/em>, <em>scalability<\/em>, <em>security<\/em> and <em>cost effectiveness<\/em> with inherent SQL backup capabilities that are leveraged by using <strong>native APIs<\/strong>, to yield high fidelity backups and restores. The <em>key value propositions<\/em> of this solution are:<\/p>\n<ol>\n<li><strong>15-minute Recovery Point Objective<\/strong> <strong>(RPO):<\/strong> Working with uber critical data and have a low RPO? Schedule a log backup to happen every 15 minutes.<\/li>\n<li><strong>One-click, point-in-time restores:<\/strong> Tired of elaborate manual restore procedures? Restore databases 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.<\/li>\n<li><strong>Long-term retention:<\/strong> Rigorous compliance and audit needs? Retain your backups for years, based on the retention duration, beyond which the recovery points will be pruned automatically by the built-in lifecycle management capability.<\/li>\n<li><strong>Protection for encrypted databases:<\/strong> Concerned about security of your data and backups? Back-up SQL encrypted databases and secure backups with built-in encryption at rest while controlling backup and restore operations with Role-Based Access Control.<\/li>\n<li><a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-backup-can-automatically-protect-sql-databases-in-azure-vm-through-auto-protect\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Auto-protection<\/strong><\/a><strong>:<\/strong> Dealing with a dynamic environment where new databases get added frequently? Auto-protect your server to automatically detect and protect the newly added databases.<\/li>\n<li><strong>Central management and monitoring:<\/strong> Losing too much time managing and monitoring backups for each server in isolation? Scale smartly by creating centrally managed backup policies that can be applied across databases. Monitor jobs and get alerts and emails across servers and even vaults from a single pane of glass.<\/li>\n<li><strong>Cost effective:<\/strong> No infrastructure and no overhead of managing the scale, seems like value for the money already? Enjoy reduced total cost of ownership and flexible pay-as-you-go option.<\/li>\n<\/ol>\n<h2>Get started<\/h2>\n<p>Click on the image below to watch the video, &#8220;How to back up SQL Server running in Azure VMs with Azure Backup.&#8221;<\/p>\n<p><a href=\"https:\/\/youtu.be\/wmbANpHos_E\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" alt=\"Azure portal with \u2018Restore\u2019 blade open inside the vault view that shows the graphical view of continuous log backups.\" border=\"0\" height=\"1440\" src=\"http:\/\/www.sickgaming.net\/blog\/wp-content\/uploads\/2019\/03\/now-available-azure-backup-for-sql-server-virtual-machines-the-simple-modern-way-to-do-backup-in-the-cloud-1.png\" title=\"Restore blade in Azure portal\" width=\"2560\"><\/a><\/p>\n<h2>Customer feedback<\/h2>\n<p>We have been in preview for a few months now, and have seen an overwhelming response from our customers:<\/p>\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<p align=\"right\">&#8211; Steven Hayes, Principal Architect, Acuity Brands Lighting, Inc<\/p>\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<p align=\"right\">&#8211; Celica E. Candido, Cloud Operations Analyst, Willis Towers Watson<\/p>\n<h3>Additional resources<\/h3>\n","protected":false},"excerpt":{"rendered":"<p>How do you back up your SQL Servers today? You could be using backup software that require you to manage backup servers, agents, and storage, or you could be writing elaborate custom scripts which need you to manage the backups on each server individually. With the modernization of IT infrastructure and the world rapidly moving [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":89143,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[54,50],"class_list":["post-89142","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-news","tag-azure","tag-recent-news"],"_links":{"self":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/89142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/comments?post=89142"}],"version-history":[{"count":0,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/89142\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media\/89143"}],"wp:attachment":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media?parent=89142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/categories?post=89142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/tags?post=89142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}