{"id":8848,"date":"2016-09-16T18:22:32","date_gmt":"2016-09-16T16:22:32","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/"},"modified":"2016-09-16T18:22:32","modified_gmt":"2016-09-16T16:22:32","slug":"sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/","title":{"rendered":"SQL Server 2016 : Basic availability groups may fit to your HA needs"},"content":{"rendered":"<p><span style=\"color: #000000;font-family: Calibri\">In this blog let\u2019s talk about SQL Server and availability groups in standard Edition. I had some customer questions about existing limitations and this is a good opportunity to review them on this blog post. <\/span>First of all, let\u2019s say that Microsoft has already documented the restrictions <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt614935.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a> and from my side, I already written a <a href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-availability-groups-and-the-new-potential-support-for-standard-edition\/\" target=\"_blank\" rel=\"noopener noreferrer\">blog post<\/a> on the subject at the time of the CTP version of SQL Server 2016. In the meantime, some changes occurred\u00a0and are now\u00a0included in the RTM version.<\/p>\n<p>As a reminder, the Standard Edition offers limited capabilities of availability groups and it tends to be a replacement of previous feature called mirroring. This is a good news for customers that may finally upgrade their old environment.<\/p>\n<p>The first main limitation concerns the number of replicas capped to only 2 and with no possibility to use the secondary replica for Reporting and backups offloading as well. But we want to use a Standard Edition and it is supposed to be sold at a lower cost right?<\/p>\n<p>Let\u2019s just have a quick check by using the T-SQL script. Generally speaking, I\u2019m not a big fan of the GUI! So if I try to create an availability group with 3 replicas, I will obviously face the following error message:<\/p>\n<p><em><strong>Msg 35233, Level 16, State 0, Line 2<\/strong><\/em><br \/>\n<em><strong>Cannot create an availability group containing 3 availability replica(s).\u00a0<\/strong><\/em><br \/>\n<em><strong>The maximum number of availability replicas in an availability group\u00a0 with (basic) is 2.\u00a0 <\/strong><\/em><br \/>\n<em><strong>Reenter your CREATE AVAILABILITY GROUP command specifying fewer availability replicas.<\/strong><\/em><\/p>\n<p><span style=\"color: #000000;font-family: Calibri\">Let\u2019s try to use a secondary replica as read-only replica (ALLOW_CONNECTIONS = ALL)<\/span><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">-- primary replica\nCREATE AVAILABILITY GROUP [testGrpStd]   \nFOR  \nREPLICA ON\nN'WIN20121SQL16\\SQL16STD'\nWITH (ENDPOINT_URL = N'TCP:\/\/WIN20121SQL16.dbi-services.test:5023',  \n    FAILOVER_MODE = AUTOMATIC,  \n    AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,   \n    BACKUP_PRIORITY = 50,   \n    SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL),   \n    SEEDING_MODE = MANUAL)\n,\nN'WIN20124SQL16\\SQL16STD'\nWITH (ENDPOINT_URL = N'TCP:\/\/WIN20124SQL16.dbi-services.test:5022',   \n    FAILOVER_MODE = AUTOMATIC,   \n    AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,   \n    BACKUP_PRIORITY = 50,   \n    SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL),   \n    SEEDING_MODE = MANUAL);   \nGO<\/pre>\n<p><span style=\"color: #000000;font-family: Calibri\">Well another error message I got\u00a0here:<\/span><\/p>\n<p><em><strong>Msg 41199, Level 16, State 8, Line 2<\/strong><\/em><br \/>\n<em><strong>The specified command is invalid because the Always On Availability Groups allow_connections feature <\/strong><\/em><br \/>\n<em><strong>is not supported by this edition of SQL Server. For information about features supported by the editions <\/strong><\/em><br \/>\n<em><strong>of SQL Server, see SQL Server Books Online.<\/strong><\/em><\/p>\n<p>However, I noticed a big change compared to my first test with a CTP version concerning the possibility to add a listener to my availability group. From my point of view, this is a very good improvement compared to the mirroring feature because no changes will be required at the application layer with additional options at the connection string level. Let me prove it with the following script:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">USE [master]\nGO\nALTER AVAILABILITY GROUP [testGrpStd]\nADD LISTENER N'Test-GrpSTD' (\nWITH IP\n((N'192.168.5.122', N'255.255.255.0')\n)\n, PORT=1433);\nGO<\/pre>\n<p>We can check the listener creation by using DMVs to get the listener configuration as shown below:<\/p>\n<p><span style=\"color: #000000;font-family: Calibri\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10863\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1.jpg\" alt=\"blog 103 - STD AG - listener 1\" width=\"423\" height=\"68\" \/><\/a><\/span><\/p>\n<p>According to my discussions with some customers at our last SQL Server 2016 event, availability groups in Standard Edition may also suggest that more complex infrastructures like multi-subnet availability groups or new special features like direct seeding will not be supported.\u00a0A first look\u00a0at the Microsoft documentation doesn\u2019t provide any clues. You can argue that the Microsoft documentation is black-list oriented and if it is not written explicitly in the documentation it should work and you are probably right. But you know, I\u2019m curious and I was interesting to check myself on my lab environment!<\/p>\n<p>For the both suppositions, I can confirm that I didn\u2019t face any issue when creating an availability group with a different setup scenario on the top of multi-subnet WSFC or when using direct seeding. Here the script used to create my availability group with a listener and two IP addresses on different subnet. I also have enabled the direct seeding feature by configuring the SEEDING_MODE parameter to AUTOMATIC as shown below.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">-- Availability groups with SEEDING_MODE = AUTOMATIC\nCREATE AVAILABILITY GROUP [testGrpStd]   \nFOR  \nREPLICA ON\nN'WIN20121SQL16\\SQL16STD'\nWITH (ENDPOINT_URL = N'TCP:\/\/WIN20121SQL16.dbi-services.test:5023',  \n    FAILOVER_MODE = AUTOMATIC,  \n    AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,   \n    BACKUP_PRIORITY = 50,   \n    SECONDARY_ROLE(ALLOW_CONNECTIONS = NO),   \n    SEEDING_MODE = AUTOMATIC)\n,\nN'WIN20124SQL16\\SQL16STD'\nWITH (ENDPOINT_URL = N'TCP:\/\/WIN20124SQL16.dbi-services.test:5022',   \n    FAILOVER_MODE = AUTOMATIC,   \n    AVAILABILITY_MODE = SYNCHRONOUS_COMMIT,   \n    BACKUP_PRIORITY = 50,   \n    SECONDARY_ROLE(ALLOW_CONNECTIONS = NO),   \n    SEEDING_MODE = AUTOMATIC);   \nGO\n\n-- Listener with two IP addresses on a different subnet \nALTER AVAILABILITY GROUP [testGrpStd]\nADD LISTENER N'Test-GrpSTD' (\nWITH IP\n((N'192.168.5.122', N'255.255.255.0'),\n (N'192.168.50.122', N'255.255.255.0')\n)\n, PORT=1433);\nGO<\/pre>\n<p><span style=\"color: #000000;font-family: Calibri\">Now let\u2019s have a look at the availability group configuration and direct seeding parameter value<\/span><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-automatic-seeding.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-10865\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-automatic-seeding.jpg\" alt=\"blog 103 - STD AG - automatic seeding\" width=\"1024\" height=\"54\" \/><\/a><\/p>\n<p>Here the listener configuration retrieved from the <em>sys.availability_group_listeners<\/em> DMV:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10864\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-2.jpg\" alt=\"blog 103 - STD AG - listener 2\" width=\"569\" height=\"51\" \/><\/a><\/p>\n<p><span style=\"color: #000000;font-family: Calibri\">Let\u2019s take this opportunity to change the replication type to ASYNCHRONOUS. In fact, I had in mind the mirroring feature when using the asynchronous replication that was only available with Enterprise edition. This is another interesting point and now we may benefit from both asynchronous and synchronous replication mode regardless the edition. By the way this feature is clearly documented in the <\/span><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt614935.aspx\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color: #0563c1;font-family: Calibri\">BOL<\/span><\/a><span style=\"color: #000000;font-family: Calibri\">. <\/span><\/p>\n<p><span style=\"color: #000000;font-family: Calibri\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-async-replication.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-10866\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-async-replication.jpg\" alt=\"blog 103 - STD AG - async replication\" width=\"1024\" height=\"52\" \/><\/a><\/span><\/p>\n<p>Finally let\u2019s check if direct seeding works as expected. If you don\u2019t know what direct seeding is please refer to my previous <a href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-alwayson-new-way-to-add-dbs-in-ag-with-direct-seeding\/\" target=\"_blank\" rel=\"noopener noreferrer\">blog<\/a>. Just as reminder, we must first configure direct seeding on the secondary by granting the correct permission to the availability group itself.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ALTER AVAILABILITY GROUP [testGrpStd] GRANT CREATE ANY DATABASE \nGO<\/pre>\n<p><span style=\"color: #000000;font-family: Calibri\">Here we go. Let\u2019s finally add the database to my existing availability and let\u2019s see if direct seeding comes into play<\/span><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">ALTER AVAILABILITY GROUP testGrpStd ADD DATABASE test_db;  \nGO<\/pre>\n<p>To get data from direct seeding session states we may use DMVs like <em>sys.dm_hadr_automatic_seeding<\/em> and <em>sys.dm_hadr_physical_seeding_stats<\/em> as well.<\/p>\n<p><span style=\"color: #000000;font-family: Calibri\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-direct-seeding.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10867\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-direct-seeding.jpg\" alt=\"blog 103 - STD AG - direct seeding\" width=\"989\" height=\"103\" \/><\/a><\/span><\/p>\n<p><span style=\"color: #000000;font-family: Calibri\">Sounds good right?<\/span><\/p>\n<p><strong><span style=\"text-decoration: underline\"><span style=\"color: #000000;font-family: Calibri\">Bottom line<\/span><\/span><\/strong><\/p>\n<p><span style=\"color: #000000;font-family: Calibri\">Basic availability groups feature is shipped with limited features. Yes, but in a meantime it will still respond to a large number of customer scenarios where we have to find a balance between high availability options and costs. Referring to some discussions I had with some customers, they don\u2019t need special features provided by availability groups like readable secondaries or offloading backups. They just want to benefit from high availability for only some critical applications. I\u2019m looking forward to see basic availability groups at customer shops!<\/span><\/p>\n<p>By David Barbarin<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog let\u2019s talk about SQL Server and availability groups in standard Edition. I had some customer questions about existing limitations and this is a good opportunity to review them on this blog post. First of all, let\u2019s say that Microsoft has already documented the restrictions here and from my side, I already written [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":8854,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[466,297,921,566],"type_dbi":[],"class_list":["post-8848","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-alwayson","tag-availability-groups","tag-basic-availability-groups","tag-sql-server-2016"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL 2016: Basic availability groups may fit to your needs<\/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.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 : Basic availability groups may fit to your HA needs\" \/>\n<meta property=\"og:description\" content=\"In this blog let\u2019s talk about SQL Server and availability groups in standard Edition. I had some customer questions about existing limitations and this is a good opportunity to review them on this blog post. First of all, let\u2019s say that Microsoft has already documented the restrictions here and from my side, I already written [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-16T16:22:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"423\" \/>\n\t<meta property=\"og:image:height\" content=\"68\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server 2016 : Basic availability groups may fit to your HA needs\",\"datePublished\":\"2016-09-16T16:22:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/\"},\"wordCount\":868,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg\",\"keywords\":[\"AlwaysOn\",\"Availability groups\",\"Basic availability groups\",\"SQL Server 2016\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/\",\"name\":\"SQL 2016: Basic availability groups may fit to your needs\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg\",\"datePublished\":\"2016-09-16T16:22:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg\",\"width\":423,\"height\":68},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 : Basic availability groups may fit to your HA needs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL 2016: Basic availability groups may fit to your needs","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.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 : Basic availability groups may fit to your HA needs","og_description":"In this blog let\u2019s talk about SQL Server and availability groups in standard Edition. I had some customer questions about existing limitations and this is a good opportunity to review them on this blog post. First of all, let\u2019s say that Microsoft has already documented the restrictions here and from my side, I already written [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/","og_site_name":"dbi Blog","article_published_time":"2016-09-16T16:22:32+00:00","og_image":[{"width":423,"height":68,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server 2016 : Basic availability groups may fit to your HA needs","datePublished":"2016-09-16T16:22:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/"},"wordCount":868,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg","keywords":["AlwaysOn","Availability groups","Basic availability groups","SQL Server 2016"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/","name":"SQL 2016: Basic availability groups may fit to your needs","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg","datePublished":"2016-09-16T16:22:32+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-103-STD-AG-listener-1-1.jpg","width":423,"height":68},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-basic-availability-groups-may-fit-to-your-ha-needs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 : Basic availability groups may fit to your HA needs"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8848"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8854"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8848"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}