Post reply

Question about mirroring.

  • July 6, 2010 at 7:58 am

    #224547

    Hello Everyone,

    I was just wondering, if a person happens to log onto a SQL server and finds that one of the databases is being mirrored, is there a way of finding out where the principle database is located?

    Regards,

    D.

  • July 6, 2010 at 8:34 am

    #1189123

    SELECT d.name, d.database_id, m.mirroring_role_desc,

    m.mirroring_state_desc, m.mirroring_safety_level_desc,

    m.mirroring_partner_name, m.mirroring_partner_instance,

    m.mirroring_witness_name, m.mirroring_witness_state_desc

    FROM sys.database_mirroring m JOIN sys.databases d

    ON m.database_id = d.database_id

    WHERE mirroring_state_desc IS NOT NULL

    ---------------------------------------------------------------------

  • July 6, 2010 at 9:55 am

    #1189169

    Marrrrvelous!

    Thank you very much!

    Regards,

    D.

  • July 8, 2010 at 5:42 am

    #1190164

    Database mirroring endpoints also shows important information about mirroring

    select * from sys.database_mirroring_endpoints

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply