SQL Server Performance

Failover

Discussion in 'SQL Server 2005 Clustering' started by Jackson, Oct 8, 2008.

  1. Jackson New Member

    Hi,
    How does failover work in the SQL Server with two instances. Both the instances fail or only one can fail at a time . Please, let me know.
    Thanks
  2. ghemant Moderator

  3. Elisabeth Redei New Member

    Hi Jackson,
    If the entire node goes down then both would failover (and in the unlikely event that the two SQL Server instances crashed simultaneously); if only one of your instances are failing then only that would failover.
    With regards to failing over, everything in a cluster happens on the Virtual Server level (which is the group of components you have setup together such as IP address, netname, SQL Server, some disks etc.). There are no dependencies between such Virtual servers.
    HTH!
    /Elisabeth

Share This Page