WMI event for mirroring

• AAKR

  SSCommitted

  Points: 1586

  More actions

  March 4, 2013 at 3:16 pm

  #271943

  Hi Friends,

  I have to implement Mirroring on 4 databases.

  1. How can I write code for Failover for all databases. If one DB got failover I want it to failover all the databses. For this I want create a WMI event for Each DB can any one know the script please reply me back.

  Thank you in Advance 🙂

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  March 11, 2013 at 9:55 am

  #1595636

  Please go through this link- answer is here.

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

  Is your DBmirroring setup in synchronous mode or asynchronous mode?