Cluster failover

  • We have all our production databases in SQL Cluster server (active/passive)

    We have to perform one maintenance task in active server, so planning to failover to passive server.

    Can we expect any application downtime with this failing over to another node?

    Thanks-

  • yes there will be downtime as the resources need to move from node1 to node2. the amount of time depends on the environment, in clusters I've worked with before failover is less than 3 minutes but could be more or less in your environment

  • When there is a failover happens sql services got recycled.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply