{"id":14283,"date":"2019-12-18T08:56:54","date_gmt":"2019-12-18T08:56:54","guid":{"rendered":"https:\/\/dbtut.com\/?p=14283"},"modified":"2019-12-18T11:17:49","modified_gmt":"2019-12-18T11:17:49","slug":"how-to-create-basic-availability-group-in-sql-server-standart-edition","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/","title":{"rendered":"How To Create Basic Availability Group in SQL Server Standart Edition"},"content":{"rendered":"

What is Basic Availability Groups?<\/h2>\n

As of SQL Server 2016, we can create Always ON Availability Groups in Standard Edition with some limitations. You should read the article\u00a0 “SQL Server Always ON Availability Group”\u00a0 to learn detailed information about Always On Availaibility Groups.<\/p>\n

You can create Basic Availability Groups for a single database, as in Database Mirroring technology, and support only 1 replica. You may want to read the article “Database Mirroring On SQL Server”<\/p>\n

We can create Basic Availability Groups in the same way that we create the Availability Groups in the Enterprise Edition.<\/p>\n

Basic Availability Group Limitations<\/h2>\n
    \n
  1. We can only create for 1 database. We cannot include more than 1 database into an availability group.<\/li>\n
  2. It supports only 2 replica.(primary and secondary)<\/li>\n
  3. It can run in synchronous-commit or asynchronous-commit mode as in Enterprise Edition.<\/li>\n
  4. We can not enable read from secondary database. In Enterprise Edition we can enable read from secondary database. You may want to read the article “Readable Secondary On SQL Server Always On Availability Group”<\/li>\n
  5. We cannot check consistency with DBCC CHECKDB in the secondary database. You can find details about DBCC CHECKDB in the article “DBCC CHECKDB Command On SQL Server”.<\/li>\n
  6. We cannot upgrade Basic Availability Groups to Advanced Availability Groups in Enterprise Edition.<\/li>\n
  7. Basic Availability Groups cannot be part of Distributed Availability Groups.<\/li>\n
  8. We can not create through SSMS with SQL Server 2016. You can create a Basic Availability Group by using the TSQL script in the following link with the WITH BASIC command.<\/li>\n<\/ol>\n

    https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/create-availability-group-transact-sql<\/a><\/p>\n

    <\/div>\n

    <\/path><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"excerpt":{"rendered":"

    What is Basic Availability Groups? As of SQL Server 2016, we can create Always ON Availability Groups in Standard Edition with some limitations. You should read the article\u00a0 “SQL Server Always ON Availability Group”\u00a0 to learn detailed information about Always On Availaibility Groups. You can create Basic Availability Groups for a single database, as in …<\/p>\n

    <\/div>\n

    <\/path><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"author":1,"featured_media":14285,"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":[6708,6706,6710,6709,6712,6711,6718,6714,6713,6715,6716,6707],"class_list":["post-14283","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-basic-availability-group","tag-basic-availability-group-limitations","tag-basic-availability-group-multiple-databases","tag-basic-availability-group-requirements","tag-basic-availability-groups","tag-basic-availability-groups-automatic-failover","tag-basic-availability-groups-in-sql-server","tag-basic-availability-groups-readable-secondary","tag-basic-availability-groups-sql-server-2016","tag-basic-availability-groups-vs-advanced-availability-groups","tag-basic-availability-groups-vs-alwayson","tag-what-is-basic-availability-groups"],"aioseo_notices":[],"yoast_head":"\nHow To Create Basic Availability Group in SQL Server Standart Edition - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Create Basic Availability Group in SQL Server Standart Edition\" \/>\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\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create Basic Availability Group in SQL Server Standart Edition - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Create Basic Availability Group in SQL Server Standart Edition\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-18T08:56:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-18T11:17:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png\" \/>\n\t<meta property=\"og:image:width\" content=\"529\" \/>\n\t<meta property=\"og:image:height\" content=\"284\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Create Basic Availability Group in SQL Server Standart Edition\",\"datePublished\":\"2019-12-18T08:56:54+00:00\",\"dateModified\":\"2019-12-18T11:17:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/\"},\"wordCount\":266,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png\",\"keywords\":[\"basic availability group\",\"Basic Availability Group Limitations\",\"basic availability group multiple databases\",\"basic availability group requirements\",\"basic availability groups\",\"basic availability groups automatic failover\",\"basic availability groups in sql server\",\"basic availability groups readable secondary\",\"basic availability groups sql server 2016\",\"basic availability groups vs advanced availability groups\",\"basic availability groups vs alwayson\",\"What is Basic Availability Groups?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/\",\"name\":\"How To Create Basic Availability Group in SQL Server Standart Edition - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png\",\"datePublished\":\"2019-12-18T08:56:54+00:00\",\"dateModified\":\"2019-12-18T11:17:49+00:00\",\"description\":\"How To Create Basic Availability Group in SQL Server Standart Edition\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png\",\"width\":529,\"height\":284},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create Basic Availability Group in SQL Server Standart 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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create Basic Availability Group in SQL Server Standart Edition - Database Tutorials","description":"How To Create Basic Availability Group in SQL Server Standart Edition","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\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/","og_locale":"en_US","og_type":"article","og_title":"How To Create Basic Availability Group in SQL Server Standart Edition - Database Tutorials","og_description":"How To Create Basic Availability Group in SQL Server Standart Edition","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-18T08:56:54+00:00","article_modified_time":"2019-12-18T11:17:49+00:00","og_image":[{"width":529,"height":284,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Create Basic Availability Group in SQL Server Standart Edition","datePublished":"2019-12-18T08:56:54+00:00","dateModified":"2019-12-18T11:17:49+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/"},"wordCount":266,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png","keywords":["basic availability group","Basic Availability Group Limitations","basic availability group multiple databases","basic availability group requirements","basic availability groups","basic availability groups automatic failover","basic availability groups in sql server","basic availability groups readable secondary","basic availability groups sql server 2016","basic availability groups vs advanced availability groups","basic availability groups vs alwayson","What is Basic Availability Groups?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/","name":"How To Create Basic Availability Group in SQL Server Standart Edition - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png","datePublished":"2019-12-18T08:56:54+00:00","dateModified":"2019-12-18T11:17:49+00:00","description":"How To Create Basic Availability Group in SQL Server Standart Edition","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-9.png","width":529,"height":284},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/18\/how-to-create-basic-availability-group-in-sql-server-standart-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create Basic Availability Group in SQL Server Standart 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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14283","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14283"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14283\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14285"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}