{"id":654,"date":"2023-11-22T00:29:59","date_gmt":"2023-11-22T00:29:59","guid":{"rendered":"https:\/\/test.samplewebsitelink.com\/ordba\/?p=654"},"modified":"2023-11-22T00:30:01","modified_gmt":"2023-11-22T00:30:01","slug":"add-an-azure-sql-database-to-an-autofailover-group","status":"publish","type":"post","link":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/","title":{"rendered":"Add an Azure SQL Database to an autofailover group"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Add an Azure SQL Database to an autofailover group<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>06\/19\/2019<\/li>\n\n\n\n<li>21 minutes to read<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>APPLIES TO:<\/strong>&nbsp;&nbsp;Azure SQL Database<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A&nbsp;failover group &nbsp;is a declarative abstraction layer that allows you to group multiple geo-replicated databases. Learn to configure a failover group for an Azure SQL Database and test failover using either the Azure portal, PowerShell, or the Azure CLI. In this tutorial, you&#8217;ll learn how to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a database in Azure SQL Database<\/li>\n\n\n\n<li>Create a failover group for the database between two servers.<\/li>\n\n\n\n<li>Test failover.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Prerequisites<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The portal<\/li>\n\n\n\n<li>PowerShell<\/li>\n\n\n\n<li>The Azure CLI<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">To complete this tutorial, make sure you have:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An Azure subscription.Create a free account if you don&#8217;t already have one.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1 &#8211; Create a database<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this step, you create a&nbsp;logical SQL server&nbsp;and a&nbsp;single database&nbsp;that uses AdventureWorksLT sample data. You can create the database by using Azure portal menus and screens, or by using an Azure CLI or PowerShell script in the Azure Cloud Shell.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">All the methods include setting up a server-level firewall rule to allow the public IP address of the computer you&#8217;re using to access the server. For more information about creating server-level firewall rules, see&nbsp;Create a server-level firewall. You can also set database-level firewall rules. See&nbsp;Create a database-level firewall rule.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Portal<\/li>\n\n\n\n<li>Azure CLI<\/li>\n\n\n\n<li>PowerShell<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">To create a resource group, server, and single database in the Azure portal:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Sign in to the&nbsp;portal.<\/li>\n\n\n\n<li>From the Search bar, search for and select&nbsp;<strong>Azure SQL<\/strong>.<\/li>\n\n\n\n<li>On the&nbsp;<strong>Azure SQL<\/strong>&nbsp;page, select&nbsp;<strong>Add<\/strong>.<\/li>\n\n\n\n<li><img decoding=\"async\" alt=\"\" src=\"https:\/\/ordba.net\/assets\/images\/server-mobile-clients.jpg\"><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Link to PDF :&nbsp;<a href=\"https:\/\/ordba.net\/pdf\/configure-merge-replication-between-a-serverand-mobile-clients.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Diagnose and resolve latch contention on SQL Server<\/a><\/strong>&nbsp;&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Add an Azure SQL Database to an autofailover group APPLIES TO:&nbsp;&nbsp;Azure SQL Database A&nbsp;failover group &nbsp;is a declarative abstraction layer that allows you to group multiple geo-replicated databases. Learn to configure a failover group for an Azure SQL Database and test failover using either the Azure portal, PowerShell, or the Azure CLI. In this tutorial, &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/\"> <span class=\"screen-reader-text\">Add an Azure SQL Database to an autofailover group<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":655,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[11],"tags":[],"class_list":["post-654","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Add an Azure SQL Database to an autofailover group - Ordba<\/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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Add an Azure SQL Database to an autofailover group - Ordba\" \/>\n<meta property=\"og:description\" content=\"Add an Azure SQL Database to an autofailover group APPLIES TO:&nbsp;&nbsp;Azure SQL Database A&nbsp;failover group &nbsp;is a declarative abstraction layer that allows you to group multiple geo-replicated databases. Learn to configure a failover group for an Azure SQL Database and test failover using either the Azure portal, PowerShell, or the Azure CLI. In this tutorial, &hellip; Add an Azure SQL Database to an autofailover group Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/\" \/>\n<meta property=\"og:site_name\" content=\"Ordba\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-22T00:29:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-22T00:30:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/autofailover-group.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"815\" \/>\n\t<meta property=\"og:image:height\" content=\"508\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"ordba\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ordba\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/\",\"name\":\"Add an Azure SQL Database to an autofailover group - Ordba\",\"isPartOf\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\"},\"datePublished\":\"2023-11-22T00:29:59+00:00\",\"dateModified\":\"2023-11-22T00:30:01+00:00\",\"author\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\"},\"breadcrumb\":{\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Add an Azure SQL Database to an autofailover group\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#website\",\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/\",\"name\":\"Ordba\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f\",\"name\":\"ordba\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g\",\"caption\":\"ordba\"},\"sameAs\":[\"https:\/\/test.samplewebsitelink.com\/ordba\"],\"url\":\"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Add an Azure SQL Database to an autofailover group - Ordba","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:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/","og_locale":"en_US","og_type":"article","og_title":"Add an Azure SQL Database to an autofailover group - Ordba","og_description":"Add an Azure SQL Database to an autofailover group APPLIES TO:&nbsp;&nbsp;Azure SQL Database A&nbsp;failover group &nbsp;is a declarative abstraction layer that allows you to group multiple geo-replicated databases. Learn to configure a failover group for an Azure SQL Database and test failover using either the Azure portal, PowerShell, or the Azure CLI. In this tutorial, &hellip; Add an Azure SQL Database to an autofailover group Read More &raquo;","og_url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/","og_site_name":"Ordba","article_published_time":"2023-11-22T00:29:59+00:00","article_modified_time":"2023-11-22T00:30:01+00:00","og_image":[{"width":815,"height":508,"url":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-content\/uploads\/2023\/11\/autofailover-group.jpg","type":"image\/jpeg"}],"author":"ordba","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ordba","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/","url":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/","name":"Add an Azure SQL Database to an autofailover group - Ordba","isPartOf":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website"},"datePublished":"2023-11-22T00:29:59+00:00","dateModified":"2023-11-22T00:30:01+00:00","author":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f"},"breadcrumb":{"@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/2023\/11\/22\/add-an-azure-sql-database-to-an-autofailover-group\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.samplewebsitelink.com\/ordba\/"},{"@type":"ListItem","position":2,"name":"Add an Azure SQL Database to an autofailover group"}]},{"@type":"WebSite","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#website","url":"https:\/\/test.samplewebsitelink.com\/ordba\/","name":"Ordba","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.samplewebsitelink.com\/ordba\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/7365beabb32b7aa77cf0e890ee90ea0f","name":"ordba","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.samplewebsitelink.com\/ordba\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd4335bb4e225c36ce7c56a0aff84bb202ebb523ebdc5d1e1a11cc3f3e6085f3?s=96&d=mm&r=g","caption":"ordba"},"sameAs":["https:\/\/test.samplewebsitelink.com\/ordba"],"url":"https:\/\/test.samplewebsitelink.com\/ordba\/author\/ordba\/"}]}},"_links":{"self":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/654","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/comments?post=654"}],"version-history":[{"count":1,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/654\/revisions"}],"predecessor-version":[{"id":656,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/posts\/654\/revisions\/656"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media\/655"}],"wp:attachment":[{"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/media?parent=654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/categories?post=654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.samplewebsitelink.com\/ordba\/wp-json\/wp\/v2\/tags?post=654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}