MetaData about mirroring RRS feed

  • Question

  • Is there a way to query system tables or use DATABASEPROPERTY to get a list of all databases that are mirrored on a server.

    I see sys.databases has many columns involving replication, service broker, etc but I see nothing on mirroring and also I looked up DATABASEPROPERTY and DATABASEPROPERTYEX in BOL and see no properties regarding mirroring
    Tuesday, November 24, 2009 1:54 PM


  • I found a solution.



    DB_NAME(database_id) from sys.database_mirroring


    where mirroring_state IS NOT NULL

    • Marked as answer by RCC-JAXDBA2 Tuesday, November 24, 2009 2:12 PM
    Tuesday, November 24, 2009 2:11 PM