Database mirroring failover

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  January 30, 2012 at 4:21 am

  #252123

  Hi Expertz,

  Can anyone please give me a query to find when was the last database mirroring failover recorded.

  Tanx

• poojari045

  SSChasing Mays

  Points: 654

  More actions

  January 30, 2012 at 4:39 am

  #1439897

  Eswin (1/30/2012)

  ---

  Hi Expertz,

  Can anyone please give me a query to find when was the last database mirroring failover recorded.

  Check this

  http://www.mssqltips.com/sqlservertip/1564/database-mirroring-automating-failover-for-multiple-sql-server-databases/

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  January 30, 2012 at 8:58 pm

  #1440331

  This was not helpful. Is there some query that doesn't require to create any trigger,sp etc.

  Tanx

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  January 31, 2012 at 3:06 am

  #1440447

  See if sp_readerrorlog 0,1,'mirror', 'failover' (or some variation thereof) works for you.

  For more in depth monitoring of mirroring events you may need to look into capturing WMI events via SQL Agent alerts.

  Cheers

• steve smith-401573

  SSChampion

  Points: 10889

  More actions

  February 6, 2012 at 2:56 pm

  #1443466

  If you don't limit yourself to a defined query, you can try examining either the SQL Server logs or the System Application logs. Generally you will receive the same event messages in both logs; depending on activity and filtering options, you can usually land on the messages in question pretty quickly.

  How frequently will you need to answer this question? If it is not a frequent question, you will probably want to browse the logs to identify the context of other/related events surrounding the fail over, such as lost communications without triggering a fail over.