locked
clustering RRS feed

  • Question

  • Hi all,

    In active node one query is running , it  take 15 minutes time . But after 5 minutes in the active node fail over is happened.

    how to the fail over process happening in cluster..?

    Tuesday, June 11, 2013 9:23 AM

Answers

  • hi ,

    when failover happens SQL server services are restarted so your query will be rolled back i think,

    If its update going on whole transaction will be rolled back and you have to run the query again.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by SLNSH Tuesday, June 11, 2013 10:04 AM
    Tuesday, June 11, 2013 9:33 AM