Still use SQL Server Database Mirroring - List all DBs and status for alerting
List all Mirrored Databases and status on a SQL Server Instance: To list all databases in a SQL Server instance with a little information or even a lot of information for all databases configured for mirroring use the following queries: Reminder The mirroring_state numbers represent the following: 0 = Suspended 1 = Disconnected from the other partner 2 = Synchronizing 3 = Pending Failover 4 = Synchronized 5 = The partners are not synchronized. Failover is not possible now Below is a comparison and methodology for stepping through example until you refine what you want to see. Enjoy! 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 USE master GO SELECT d . name AS Database_Name , CASE ...