Run script in the event of failover

• Henrik Andersson

  SSC Enthusiast

  Points: 178

  More actions

  June 13, 2006 at 7:18 am

  #114546

  Hi!

  I have set up mirroring with a witness on SQL 2005. I was wondering - is it possible to run a script file automatically when the witness detects that server 1 is down, and switches principal?

  I have some COM-services and a MSMQ-service that need to be started in the event of failure.

• peterhe

  SSChampion

  Points: 11469

  More actions

  June 14, 2006 at 6:49 am

  #643619

  You can try to set up event notification to monitor

  Database_Mirroring_State_Change trace event. When it happens, run your script in the event handler.