O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Installing Multi-instance (Active/Active) Failover Cluster

We have just covered the installation procedure for the Single-instance Failover Cluster for SQL Server 2008 R2. Now let's move on and have a look at Multi-instance, that is, the Active/Active Failover Cluster. Before we get started, I would like to clear some queries.

  • Query: What is the difference between Active/Passive and Active/Active Failover Cluster?

    Answer:In reality, there is only one difference between Single-instance (Active/Passive Failover Cluster) and Multi-instance (Active/Active Failover Cluster). As its name suggests, in a Multi-instance cluster, there will be two or more SQL Server active instances running in a cluster, compared to one instance running in Single-instance. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required