DB Mirroring Query

  • Hi All....

    is there a way of finding out what account my existing mirrored DB's are using?

    Cheers

    Pete

  • Not entirely sure what you are asking.. Are you looking to find out what service accounts the mirroring service is using to connect to the various mirroring servers? Look at the principal_name and remote_user_name columns in master.sys.dm_db_mirroring_connections on the principal.

    If you are asking what logins are being used to connect to the mirrored databases, you can look in the security folder of the mirrored database to see the ones allowed in or the Activity Monitor to see the ones currently in use.

    Shaun

Viewing 2 posts - 1 through 1 (of 1 total)

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