SQL 2008 SP1 - Mirroring with witness: enable / disable jobs automatically RRS feed

  • Question

  • Hello All !

    I have a mirroring database solution with SQL 2008 SP1 (1 principal, 1 mirror and a witness) in production. If failover occurs (planned or unplanned), when the principal or mirror is fallen,  I want to enable / disable automatically some sql agent jobs (backup, defrag, etc) on the concerned partner.

    Does this operation must be run by a witness process ? or when mirror is up ? How can I detect that the mirror is up ? and the same thing for principal to stop the jobs when  ? Scripts ? Query ? I don't know ... and how does this ?

    Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2
    Wednesday, October 20, 2010 1:01 PM