locked
Checking Principal and Mirror Server RRS feed

  • Question

  • Dear all,

    I am checking the principal connect and mirror connect of two server.

    When changing between them, My app is showing two prinicpal connect of using below statement

    select 
    Case
        when State_desc ='Online' then 'Principal connect' 
        when State_desc ='Restoring' then 'Mirror connect' 
        else
         'Disconnected'
        End
    from master.sys.databases
    Where Name = '<dbname>'

    But when I close the application and reopen the application, it show correct one principal and one mirror connection.

    Do you have any hints??? Is my situation normal??

    Tuesday, June 14, 2011 6:39 AM

Answers