• Check the cluster logs and the event logs to see if you can find a reason for the service to fail over.

    Agent XPs are always switched to 0 as a SQL server shuts down. It's not the cause of the failure.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass