{"id":1575,"date":"2018-08-12T13:00:38","date_gmt":"2018-08-12T13:00:38","guid":{"rendered":"http:\/\/dbtut.com\/?p=1575"},"modified":"2018-11-09T22:46:25","modified_gmt":"2018-11-09T22:46:25","slug":"set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/","title":{"rendered":"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition ."},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>For Always on Perrequisite Refer Document<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"0Cyw0jucQE\"><p><a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/prerequisite-for-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\">Prerequisite  For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition .<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Prerequisite  For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition .&#8221; &#8212; Database Tutorials\" src=\"https:\/\/dbtut.com\/index.php\/2018\/08\/09\/prerequisite-for-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/embed\/#?secret=0Ix3CKhvY2#?secret=0Cyw0jucQE\" data-secret=\"0Cyw0jucQE\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>Specify the name of the Availability that you want to create.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1576\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png\" alt=\"\" width=\"328\" height=\"155\" \/><\/p>\n<p>Please also note the new option \u201cDatabase level Health Detection\u201d. In SQL SERVER 2016 You can now configure AlwaysOn Availability Groups to failover when a database goes offline. This was not possible in previous editions of SQL Server.<\/p>\n<p>Select the database that you want to add to the Availability Group. One of the limitations of Basic HA is that you\u2019re only allowed to add 1 database per group. The wizard will return an error when you try to add more than 1 database into the group.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1583\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGDBNAME-1.png\" alt=\"\" width=\"685\" height=\"367\" \/><\/p>\n<p>When you specify the replicas for your Availability Group, you will notice 2 other limitations:<\/p>\n<ul>\n<li>Limit of two replicas (primary and secondary). After you\u2019ve added the secondary replica, the \u201cAdd Replica\u201d button will automatically be disabled.<\/li>\n<li>No read access on secondary replica. The wizard only has the \u201cNo\u201d option, so you can\u2019t configure a readable secondary.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1577\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/replica-1.png\" alt=\"\" width=\"683\" height=\"327\" \/><\/li>\n<\/ul>\n<p>Please note that you can configure Synchronous or Asynchronous commit mode. This is a difference compared to database mirroring where you could only use synchronous commit mode in SQL Server Standard Edition. With Basic HA, we allow asynchronous commit mode, to be able to create your secondary replica in Azure. This allows you to create even a basic disaster recovery solution with SQL Server Standard Edition!The endpoint configuration is still needed and there is no difference compared to the traditional Enterprise Availability Groups<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1578\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/endpoints-1.png\" alt=\"\" width=\"670\" height=\"203\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Basic HA doesn\u2019t allow you to use a readable secondary, which means that there are no backups possible on the secondary replica. You will notice that the Backup Preferences are completely disabled<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1579\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/BACKUP-STATUS-1.png\" alt=\"\" width=\"684\" height=\"444\" \/><\/p>\n<p>Basic HA also supports the usage of an Availability Group Listener. Creating the listener is the same procedure as the traditional Enterprise listener. The Basic HA group is limited to 1 listener.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1580\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/Listener-1.png\" alt=\"\" width=\"696\" height=\"441\" \/><\/p>\n<p>The next step is setting up the data synchronization between the 2 replicas. Again, there is no difference here between Standard and Enterprise Edition<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1581\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/DATA-SYNC-3.png\" alt=\"\" width=\"714\" height=\"335\" \/><\/p>\n<p>With SQL Sever 2016, you could also use the new option Direct Seeding. This method will seed the secondary replica over the network. It does not require you to backup and restore a copy of the primary database on the replica. However, this is currently not available in the wizard but only with T-SQL.<\/p>\n<p>After you finish the wizard, you have setup your first Basic HA Availability Group.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1582\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGWITH-DB-1.png\" alt=\"\" width=\"506\" height=\"274\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1575\" class=\"pvc_stats all  \" data-element-id=\"1575\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; For Always on Perrequisite Refer Document Prerequisite For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . &nbsp; Specify the name of the Availability that you want to create. Please also note the new option \u201cDatabase level Health Detection\u201d. In &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1575\" class=\"pvc_stats all  \" data-element-id=\"1575\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":69,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[1393,1390,1392,1391],"class_list":["post-1575","post","type-post","status-publish","format-standard","","category-mssql","tag-ha-for-sql-server-2016","tag-sql-server-2016-always-on","tag-sql-server-2016-mirroring","tag-standard-edition-always-on"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . - Database Tutorials<\/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:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"&nbsp; For Always on Perrequisite Refer Document Prerequisite For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . &nbsp; Specify the name of the Availability that you want to create. Please also note the new option \u201cDatabase level Health Detection\u201d. In &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-12T13:00:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-09T22:46:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png\" \/>\n<meta name=\"author\" content=\"Rajeev Shastri\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rajeev_shastri\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rajeev Shastri\" \/>\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\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\"},\"author\":{\"name\":\"Rajeev Shastri\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f512ff3e1ca89282b294d4713ce11fdb\"},\"headline\":\"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition .\",\"datePublished\":\"2018-08-12T13:00:38+00:00\",\"dateModified\":\"2018-11-09T22:46:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\"},\"wordCount\":432,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png\",\"keywords\":[\"HA FOR SQL SERVER 2016\",\"SQL SERVER 2016 ALWAYS ON\",\"SQL SERVER 2016 MIRRORING\",\"standard edition always on\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\",\"name\":\"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png\",\"datePublished\":\"2018-08-12T13:00:38+00:00\",\"dateModified\":\"2018-11-09T22:46:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition .\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f512ff3e1ca89282b294d4713ce11fdb\",\"name\":\"Rajeev Shastri\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5a899739ebd3b3816b929dbb11a59f6fec8961873e77d6c36c6582a046fe4280?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5a899739ebd3b3816b929dbb11a59f6fec8961873e77d6c36c6582a046fe4280?s=96&d=mm&r=g\",\"caption\":\"Rajeev Shastri\"},\"description\":\"Database Administrator With experience on SQL SERVER,Oracle and NOSQL DB\",\"sameAs\":[\"https:\/\/x.com\/rajeev_shastri\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/rajeevshastri\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . - Database Tutorials","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:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/","og_locale":"en_US","og_type":"article","og_title":"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . - Database Tutorials","og_description":"&nbsp; For Always on Perrequisite Refer Document Prerequisite For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . &nbsp; Specify the name of the Availability that you want to create. Please also note the new option \u201cDatabase level Health Detection\u201d. In &hellip;","og_url":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-12T13:00:38+00:00","article_modified_time":"2018-11-09T22:46:25+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png","type":"","width":"","height":""}],"author":"Rajeev Shastri","twitter_card":"summary_large_image","twitter_creator":"@rajeev_shastri","twitter_misc":{"Written by":"Rajeev Shastri","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/"},"author":{"name":"Rajeev Shastri","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f512ff3e1ca89282b294d4713ce11fdb"},"headline":"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition .","datePublished":"2018-08-12T13:00:38+00:00","dateModified":"2018-11-09T22:46:25+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/"},"wordCount":432,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png","keywords":["HA FOR SQL SERVER 2016","SQL SERVER 2016 ALWAYS ON","SQL SERVER 2016 MIRRORING","standard edition always on"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/","url":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/","name":"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition . - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png","datePublished":"2018-08-12T13:00:38+00:00","dateModified":"2018-11-09T22:46:25+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/AGNAME-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/08\/12\/set-up-alwayson-basic-availability-groups-in-sql-server-2016-in-standard-edition-or-sql-server-mirroring-in-sql-server-2016-in-standard-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Set Up AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in SQL Server 2016 in Standard Edition ."}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f512ff3e1ca89282b294d4713ce11fdb","name":"Rajeev Shastri","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5a899739ebd3b3816b929dbb11a59f6fec8961873e77d6c36c6582a046fe4280?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5a899739ebd3b3816b929dbb11a59f6fec8961873e77d6c36c6582a046fe4280?s=96&d=mm&r=g","caption":"Rajeev Shastri"},"description":"Database Administrator With experience on SQL SERVER,Oracle and NOSQL DB","sameAs":["https:\/\/x.com\/rajeev_shastri"],"url":"https:\/\/dbtut.com\/index.php\/author\/rajeevshastri\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/69"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=1575"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1575\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}