{"id":11734,"date":"2019-04-25T17:46:25","date_gmt":"2019-04-25T17:46:25","guid":{"rendered":"https:\/\/dbtut.com\/?p=11734"},"modified":"2019-04-25T17:48:06","modified_gmt":"2019-04-25T17:48:06","slug":"how-to-list-databases-not-included-in-the-availability-groupstandalone-databases","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/","title":{"rendered":"How To List Databases Not Included in the Availability Group(Standalone Databases)"},"content":{"rendered":"<p>In particular, if you are using Always On Availability Group and you haven&#8217;t included some of your databases to an always on availability groups, in some cases you may need list of databases that are not in the availability group.<\/p>\n<p>You can learn more about Always On Availability Group from the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/18\/sql-server-always-on-availability-group\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Always On Availability Group<\/a>&#8221;<\/p>\n<p>The following 2 scripts provide a list of standalone databases on the instance. I wrote the second one when I couldn&#8217;t find the first one. You can use whichever you want.<\/p>\n<h3>Script 1<\/h3>\n<pre class=\"lang:default decode:true \">Select name from sys.sysdatabases where name not in(\nSelect DISTINCT\ndrcs.database_name AS name\nFROM master.sys.availability_groups AS ag\nLEFT OUTER JOIN master.sys.dm_hadr_availability_group_states as ags\n\u00a0\u00a0 ON ag.group_id = ags.group_id\nINNER JOIN master.sys.availability_replicas AS ar\n\u00a0\u00a0 ON ag.group_id = ar.group_id\nINNER JOIN master.sys.dm_hadr_availability_replica_states AS ars\n\u00a0\u00a0 ON ar.replica_id = ars.replica_id AND ars.is_local = 1\nINNER JOIN master.sys.dm_hadr_database_replica_cluster_states AS drcs\n\u00a0\u00a0 ON ars.replica_id = drcs.replica_id\nLEFT OUTER JOIN master.sys.dm_hadr_database_replica_states AS dbrs\n\u00a0\u00a0 ON drcs.replica_id = dbrs.replica_id AND drcs.group_database_id = dbrs.group_database_id\nWHERE ISNULL(ars.role, 3) = 1 OR ISNULL(drcs.is_database_joined, 0) = 1\n)and dbid &gt;4 order by name asc\n<\/pre>\n<h3>Script 2<\/h3>\n<pre class=\"lang:default decode:true \">SELECT name FROM sys.sysdatabases where dbid&gt;4 and name not in(\nSELECT  DB_NAME(drs.database_id) as name\nFROM (( sys.availability_groups AS ag JOIN sys.availability_replicas AS ar ON ag.group_id = ar.group_id )\nJOIN sys.dm_hadr_availability_replica_states AS ars ON ar.replica_id = ars.replica_id)\nJOIN sys.dm_hadr_database_replica_states AS drs on ag.group_id = drs.group_id\nand drs.replica_id = ars.replica_id\nwhere ars.role_desc='PRIMARY' OR ars.role_desc='SECONDARY')\n<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11734\" class=\"pvc_stats all  \" data-element-id=\"11734\" 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>In particular, if you are using Always On Availability Group and you haven&#8217;t included some of your databases to an always on availability groups, in some cases you may need list of databases that are not in the availability group. You can learn more about Always On Availability Group from the article named &#8220;SQL Server &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11734\" class=\"pvc_stats all  \" data-element-id=\"11734\" 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":1,"featured_media":11736,"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":[3587,3592,3589,3588,3590,3591],"class_list":["post-11734","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-list-databases-in-sql-server","tag-list-databases-not-in-availability-group","tag-list-standalone-databases-in-sql-server","tag-list-standalone-databases-in-the-instance","tag-sql-list-databases-in-availability-group","tag-sql-list-databases-not-in-availability-group"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To List Databases Not Included in the Availability Group(Standalone Databases) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To List Databases Not Included in the Availability Group\" \/>\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\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To List Databases Not Included in the Availability Group(Standalone Databases) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To List Databases Not Included in the Availability Group\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-25T17:46:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-25T17:48:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png\" \/>\n\t<meta property=\"og:image:width\" content=\"599\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\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=\"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\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To List Databases Not Included in the Availability Group(Standalone Databases)\",\"datePublished\":\"2019-04-25T17:46:25+00:00\",\"dateModified\":\"2019-04-25T17:48:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/\"},\"wordCount\":106,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png\",\"keywords\":[\"list databases in sql server\",\"list databases not in availability group\",\"list standalone databases in sql server\",\"list standalone databases in the instance\",\"sql list databases in availability group\",\"sql list databases not in availability group\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/\",\"name\":\"How To List Databases Not Included in the Availability Group(Standalone Databases) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png\",\"datePublished\":\"2019-04-25T17:46:25+00:00\",\"dateModified\":\"2019-04-25T17:48:06+00:00\",\"description\":\"How To List Databases Not Included in the Availability Group\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png\",\"width\":599,\"height\":350},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To List Databases Not Included in the Availability Group(Standalone Databases)\"}]},{\"@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 List Databases Not Included in the Availability Group(Standalone Databases) - Database Tutorials","description":"How To List Databases Not Included in the Availability Group","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\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/","og_locale":"en_US","og_type":"article","og_title":"How To List Databases Not Included in the Availability Group(Standalone Databases) - Database Tutorials","og_description":"How To List Databases Not Included in the Availability Group","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-25T17:46:25+00:00","article_modified_time":"2019-04-25T17:48:06+00:00","og_image":[{"width":599,"height":350,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To List Databases Not Included in the Availability Group(Standalone Databases)","datePublished":"2019-04-25T17:46:25+00:00","dateModified":"2019-04-25T17:48:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/"},"wordCount":106,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png","keywords":["list databases in sql server","list databases not in availability group","list standalone databases in sql server","list standalone databases in the instance","sql list databases in availability group","sql list databases not in availability group"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/","name":"How To List Databases Not Included in the Availability Group(Standalone Databases) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png","datePublished":"2019-04-25T17:46:25+00:00","dateModified":"2019-04-25T17:48:06+00:00","description":"How To List Databases Not Included in the Availability Group","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-49.png","width":599,"height":350},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/25\/how-to-list-databases-not-included-in-the-availability-groupstandalone-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To List Databases Not Included in the Availability Group(Standalone Databases)"}]},{"@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\/11734","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=11734"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11734\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11736"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}