{"id":39035,"date":"2024-02-08T16:48:09","date_gmt":"2024-02-08T15:48:09","guid":{"rendered":"https:\/\/www.schneider.systems\/?p=39035"},"modified":"2024-02-08T16:48:09","modified_gmt":"2024-02-08T15:48:09","slug":"microsoft-azure-sql-database-failover-rights-save-on-costs","status":"publish","type":"post","link":"https:\/\/www.schneider.systems\/lu\/microsoft-azure-sql-database-failover-rights-save-on-costs\/","title":{"rendered":"Microsoft Azure SQL Database failover rights: Save on costs"},"content":{"rendered":"<p style=\"text-align: justify;\">Starting from December 1, 2023, you can benefit from the <strong>new failover rights<\/strong> for <strong>Azure SQL Database<\/strong>, which allow you to <strong>reduce your licensing costs<\/strong> <strong>for<\/strong> <strong>disaster recovery scenarios<\/strong>. If you have a <strong>secondary database replica<\/strong> that is <strong>only used for disaster recovery purposes<\/strong>, and has <strong>no active workloads or connections<\/strong>, you can <strong>mark it as a standby replica<\/strong>. This way, you <strong>don\u2019t have to pay for the vCores licensed in the primary database<\/strong>, and only pay for the compute and storage resources consumed by the secondary database.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-39036\" src=\"https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights.jpg\" alt=\"\" width=\"800\" height=\"514\" srcset=\"https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights.jpg 800w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-300x193.jpg 300w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-150x96.jpg 150w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-768x493.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\">What are the benefits of using standby replicas?<\/h2>\n<p style=\"text-align: justify;\">Using standby replicas can help you achieve the following benefits:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Lower costs:<\/strong> You can save up to 50% on licensing costs for disaster recovery, as you only pay for the vCores used by the primary database, and not the secondary database.<\/li>\n<li><strong>Simplified management:<\/strong> You can easily designate a secondary database as a standby replica by using the <a href=\"https:\/\/portal.azure.com\/\">Azure portal<\/a>, Azure PowerShell, or Azure CLI. You can also monitor the status and usage of your standby replicas from the Azure portal.<\/li>\n<li><strong>Business continuity:<\/strong> You can still use the failover groups feature to manage the replication and failover of your databases across regions. You can also use the read-only listener endpoint to offload read-only workloads to the secondary database, if needed.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\">How do I enable standby replicas for my databases?<\/h2>\n<p style=\"text-align: justify;\">To <strong>enable<\/strong> <strong>standby<\/strong> <strong>replicas<\/strong> for your databases, you need to do the following <strong>steps<\/strong>:<\/p>\n<ol style=\"text-align: justify;\">\n<li><strong>Create a failover group:<\/strong> A failover group is a logical grouping of databases that are replicated and failed over together. You can create a failover group by using the <a href=\"https:\/\/portal.azure.com\/\">Azure portal<\/a>, Azure PowerShell, or Azure CLI. You need to specify a primary server and a secondary server in different regions, and select the databases you want to include in the failover group. For more details, see\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/failover-group-configure-sql-db?view=azuresql\">Configure a failover group<\/a>.<\/li>\n<li><strong>Mark a secondary database as a standby replica:<\/strong> After creating a failover group, you can mark a secondary database as a standby replica by using the Azure portal, Azure PowerShell, or Azure CLI. You need to set the\u00a0&#8220;Standby&#8221;\u00a0property of the database to\u00a0&#8220;True&#8221;. For more details, see\u00a0<a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/failover-group-sql-db?view=azuresql\">Mark a secondary database as a standby replica<\/a>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-39041\" src=\"https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-2-1024x513.jpg\" alt=\"\" width=\"800\" height=\"401\" srcset=\"https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-2-1024x513.jpg 1024w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-2-300x150.jpg 300w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-2-150x75.jpg 150w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-2-768x384.jpg 768w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-2-1536x769.jpg 1536w, https:\/\/www.schneider.systems\/media\/2024\/02\/SCHNEIDER-IT-MANAGEMENT-2024-02-07-Update-Microsoft-Azure-SQL-Database-failover-rights-2-2048x1025.jpg 2048w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\">What are the limitations and considerations of using standby replicas?<\/h2>\n<p style=\"text-align: justify;\">Before using <strong>standby<\/strong> <strong>replicas<\/strong>, you need to be aware of the following <strong>limitations<\/strong> and <strong>considerations<\/strong>:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Licensing requirements:<\/strong> To use standby replicas, you need to have an active Software Assurance or Hybrid Benefit for your primary database. You also need to ensure that the primary and secondary databases have the same service tier, compute size, and storage size.<\/li>\n<li><strong>Availability SLA:<\/strong> Standby replicas are not covered by the availability Service Level Agreement (SLA) of Azure SQL Database. If the secondary server or region becomes unavailable, you may not be able to fail over to the standby replica or restore it to another region. An availability SLA is a type of service level agreement (SLA) that specifies the percentage of time that a service is available and operational during a given period, excluding any planned or agreed downtime. For example, an availability SLA of 99.9% means that the service is expected to be up and running for at least 99.9% of the time in a month, which allows for about 43 minutes of downtime.<\/li>\n<li><strong>Data loss risk:<\/strong> Standby replicas use asynchronous replication, which means that there may be some data loss in the event of a failover. You can check the replication lag of your standby replica from the Azure portal or by using the\u00a0&#8220;sys.dm_geo_replication_link_status&#8221;\u00a0dynamic management view.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: justify;\">More information<\/h2>\n<p style=\"text-align: justify;\">For the <strong>announcement<\/strong> article, please visit: <a href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-sql-blog\/license-free-standby-replica-for-azure-sql-database\/ba-p\/3973406\">https:\/\/techcommunity.microsoft.com\/t5\/azure-sql-blog\/license-free-standby-replica-for-azure-sql-database\/ba-p\/3973406<\/a>.<\/p>\n<p style=\"text-align: justify;\">Find the <strong>new clause in the December 2023 Product Terms<\/strong> here: <a href=\"https:\/\/www.microsoft.com\/licensing\/terms\/productoffering\/MicrosoftAzure\/EAEAS#:~:text=SQL%20Server%20workloads.-,Azure%20SQL%20Database,to%20users%20or%20devices%20or%20otherwise%20run%20active%20SQL%20Server%20workloads.,-Azure%20Virtual%20Desktop\">https:\/\/www.microsoft.com\/licensing\/terms\/productoffering\/MicrosoftAzure\/EAEAS#:~:text=SQL%20Server%20workloads.-,Azure%20SQL%20Database,to%20users%20or%20devices%20or%20otherwise%20run%20active%20SQL%20Server%20workloads.,-Azure%20Virtual%20Desktop<\/a>.<\/p>\n<p style=\"text-align: justify;\">For <strong>instructions on how to configure the standby replica<\/strong>, please visit: <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/standby-replica-how-to-configure?view=azuresql-db&amp;tabs=azure-portal\">https:\/\/learn.microsoft.com\/en-us\/azure\/azure-sql\/database\/standby-replica-how-to-configure?view=azuresql-db&amp;tabs=azure-portal<\/a>.<\/p>\n<p style=\"text-align: justify;\">For software <strong>licensing information<\/strong> on <strong>Microsoft licensing programs<\/strong>, please visit: <a href=\"https:\/\/www.schneider.systems\/software\/microsoft\/\">https:\/\/www.schneider.systems\/software\/microsoft\/<\/a>.<\/p>\n<p style=\"text-align: justify;\">Please <a href=\"https:\/\/www.schneider.systems\/contact\/\">contact us<\/a> for <strong>expert services<\/strong> on your specific <strong>Microsoft<\/strong> <strong>agreements<\/strong>, <strong>more<\/strong> <strong>information<\/strong> and to <strong>request a<\/strong> <strong>quote<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Starting from December 1, 2023, you can benefit from the new failover rights for Azure SQL Database, which allow you to reduce your licensing costs for disaster recovery scenarios. If [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":33016,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[248],"tags":[],"class_list":["post-39035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-azure"],"_links":{"self":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts\/39035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/comments?post=39035"}],"version-history":[{"count":2,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts\/39035\/revisions"}],"predecessor-version":[{"id":39045,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/posts\/39035\/revisions\/39045"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/media\/33016"}],"wp:attachment":[{"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/media?parent=39035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/categories?post=39035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.schneider.systems\/lu\/wp-json\/wp\/v2\/tags?post=39035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}