How To List Databases Not Included in the Availability Group(Standalone Databases)

In particular, if you are using Always On Availability Group and you haven’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 “SQL Server Always On Availability Group

The following 2 scripts provide a list of standalone databases on the instance. I wrote the second one when I couldn’t find the first one. You can use whichever you want.

Script 1

Script 2

dbtut
Author: dbtut

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.

Leave a Reply

Your email address will not be published. Required fields are marked *