{"id":1467,"date":"2018-08-09T16:35:14","date_gmt":"2018-08-09T16:35:14","guid":{"rendered":"http:\/\/dbtut.com\/?p=1467"},"modified":"2018-11-09T21:34:44","modified_gmt":"2018-11-09T21:34:44","slug":"prerequisite-for-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\/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\/","title":{"rendered":"Prerequisite  For 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><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt614935.aspx\" target=\"_blank\" rel=\"noopener\">AlwaysOn Basic Availability Groups<\/a>\u00a0provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a deprecated feature. Basic Availability Groups are managed and created in the same way like the traditional Enterprise AlwaysOn Availability Group, but there are more limitations which are almost equally when you should run Database Mirroring on a Standard Edition.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Limitations<\/strong><\/p>\n<p>Basic availability groups use a subset of features compared to advanced availability groups on SQL Server 2016 Enterprise Edition. Basic availability groups include the following limitations:<\/p>\n<ul>\n<li>Limit of two replicas (primary and secondary).<\/li>\n<li>No read access on secondary replica.<\/li>\n<li>No backups on secondary replica.<\/li>\n<li>No integrity checks on secondary replicas.<\/li>\n<li>No support for replicas hosted on servers running a version of SQL Server prior to SQL Server 2016 Community Technology Preview 3 (CTP3).<\/li>\n<li>Support for one availability database.<\/li>\n<li>Basic availability groups cannot be upgraded to advanced availability groups. The group must be dropped and re-added to a group that contains servers running only SQL Server 2016 Enterprise Edition.<\/li>\n<li>Basic availability groups are only supported for Standard Edition servers.<\/li>\n<li>Basic availability groups can not be part of a distributed availability group.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Prerequisites<\/strong><\/p>\n<p>The prerequisites are the same as for a traditional Enterprise AlwaysOn Availability Group. You still need to Create a Windows Failover Cluster and Enable AlwaysOn Availability Groups on each instance.<\/p>\n<p>Storage for Both servers will be unique<\/p>\n<p>Shared folder need to be created to add Database in AG.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Windows Fail over CLUSTERING FEATURE\u00a0TO BOTH WINDOWS SERVERS.<\/strong><\/p>\n<p>SQL Server\u2019s AlwaysOn Availability Groups is built on top of Windows Failover Clustering Services, and you have to join your AG replicas into a single Windows cluster.<\/p>\n<p>this is nowhere near as scary as it sounds, and it can be done after-the-fact to an already-in-production SQL Server. (I\u2019d recommend you set up a lab or staging environment first to get used to it, though.)<\/p>\n<p>After installing those clustering prerequisites, open Server Manager and click\u00a0Manage, Add Roles and Features, select your server, and on the Features list, check the Failover Clustering box:<\/p>\n<figure id=\"attachment_1468\" aria-describedby=\"caption-attachment-1468\" style=\"width: 655px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1468\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png\" alt=\"\" width=\"655\" height=\"464\" \/><figcaption id=\"caption-attachment-1468\" class=\"wp-caption-text\">Window Server 2016 Cluster Feature<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>You can move on to the next step after this feature has been installed on all of the servers that will be involved in the Availability Group.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Validate your cluster candidates.<\/strong><\/p>\n<p>Open Server Manager and click Tools, Failover Cluster Manager. (I know \u2013 you thought Failover Cluster Manager would be under Manage instead of Tools. Click Validate Configuration on the right hand side to start the wizard:<\/p>\n<p>Put in the names of all the servers that will be participating in the Availability Group, and hit Next. It\u2019s going to ask if you want to run all tests \u2013 this is another one of those gotchas where, in theory, you could do this in production without an outage if you chose to run specific tests.<\/p>\n<p>Click\u00a0the View Report button, and Internet Explorer will launch because why wouldn\u2019t we take every opportunity to open a browser on a production server:<\/p>\n<p>&nbsp;<\/p>\n<p>Some errors are completely okay to ignore. The most common two are:<\/p>\n<ul>\n<li><strong>Single network interface warnings<\/strong>\u00a0\u2013 if you\u2019re doing network teaming or virtualization, you\u2019re probably protecting your network through means that the clustering wizard can\u2019t detect.<\/li>\n<li><strong>No disks found for cluster validation<\/strong>\u00a0\u2013 if you\u2019re building an AlwaysOn\u00a0configuration with no shared disk, like failover clustering on a UNC path or a pair of Availability Group replicas with local disk, this isn\u2019t a problem.<\/li>\n<\/ul>\n<p>But otherwise, read this report really carefully and fix the warnings before you go on to the next step. For example, if the two nodes have different Windows patch levels, get the missing updates installed first. (If you\u2019re having difficulty getting some of the patches to apply, there\u2019s your first sign that this isn\u2019t a good candidate for a reliable AlwaysOn implementation<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Create the Cluster.<\/strong><\/p>\n<p>After a successful validation report, leave the \u201cCreate the cluster now\u201d checkbox checked, and click Finish \u2013 your cluster will be created:<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Permissions (Windows System)<\/strong><\/p>\n<p>To administer a WSFC, the user must be a system administrator on every cluster node.<\/p>\n<p>Install SQL server 2016 standard edition on both standalone server (windows server 2016 )<\/p>\n<p>and enable always on feature for both standalone instances<\/p>\n<p>Please make sure SQL services should be running with unique domian account on Both servers<\/p>\n<p>Once always on feature enabled we can see AG option in management studio.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1467\" class=\"pvc_stats all  \" data-element-id=\"1467\" 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; AlwaysOn Basic Availability Groups\u00a0provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a deprecated feature. Basic Availability Groups are managed and created in the same way like the traditional Enterprise AlwaysOn Availability Group, but there are more limitations which are almost equally when &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_1467\" class=\"pvc_stats all  \" data-element-id=\"1467\" 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":[733,1390],"class_list":["post-1467","post","type-post","status-publish","format-standard","","category-mssql","tag-always-on","tag-sql-server-2016-always-on"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":975,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Prerequisite For 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\/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\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Prerequisite For 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; AlwaysOn Basic Availability Groups\u00a0provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a deprecated feature. Basic Availability Groups are managed and created in the same way like the traditional Enterprise AlwaysOn Availability Group, but there are more limitations which are almost equally when &hellip;\" \/>\n<meta property=\"og:url\" content=\"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\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-09T16:35:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-09T21:34:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.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=\"4 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\/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\/#article\",\"isPartOf\":{\"@id\":\"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\/\"},\"author\":{\"name\":\"Rajeev Shastri\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f512ff3e1ca89282b294d4713ce11fdb\"},\"headline\":\"Prerequisite For 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-09T16:35:14+00:00\",\"dateModified\":\"2018-11-09T21:34:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"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\/\"},\"wordCount\":771,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"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\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png\",\"keywords\":[\"Always On\",\"SQL SERVER 2016 ALWAYS ON\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"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\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"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\/\",\"url\":\"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\/\",\"name\":\"Prerequisite For 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\/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\/#primaryimage\"},\"image\":{\"@id\":\"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\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png\",\"datePublished\":\"2018-08-09T16:35:14+00:00\",\"dateModified\":\"2018-11-09T21:34:44+00:00\",\"breadcrumb\":{\"@id\":\"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\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"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\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"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\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"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\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Prerequisite For 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":"Prerequisite For 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\/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\/","og_locale":"en_US","og_type":"article","og_title":"Prerequisite For 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; AlwaysOn Basic Availability Groups\u00a0provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a deprecated feature. Basic Availability Groups are managed and created in the same way like the traditional Enterprise AlwaysOn Availability Group, but there are more limitations which are almost equally when &hellip;","og_url":"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\/","og_site_name":"Database Tutorials","article_published_time":"2018-08-09T16:35:14+00:00","article_modified_time":"2018-11-09T21:34:44+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"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\/#article","isPartOf":{"@id":"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\/"},"author":{"name":"Rajeev Shastri","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f512ff3e1ca89282b294d4713ce11fdb"},"headline":"Prerequisite For 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-09T16:35:14+00:00","dateModified":"2018-11-09T21:34:44+00:00","mainEntityOfPage":{"@id":"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\/"},"wordCount":771,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"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\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png","keywords":["Always On","SQL SERVER 2016 ALWAYS ON"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["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\/#respond"]}]},{"@type":"WebPage","@id":"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\/","url":"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\/","name":"Prerequisite For 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\/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\/#primaryimage"},"image":{"@id":"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\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png","datePublished":"2018-08-09T16:35:14+00:00","dateModified":"2018-11-09T21:34:44+00:00","breadcrumb":{"@id":"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\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["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\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"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\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/08\/CLustering-feature.png"},{"@type":"BreadcrumbList","@id":"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\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Prerequisite For 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\/1467","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=1467"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/1467\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=1467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=1467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=1467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}