O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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 and configuring Failover Cluster Services

SQL Server Failover Clustering is created within the Microsoft Cluster Services (MSCS), which is capable of detecting the hardware and software failures to switch the managed resources for the instance automatically. Clustering provides availability for the most critical applications and flexibility in managing the workload within the cluster.

The setup change for SQL Server 2008 needs to run the setup program on each node that is involved as part of the failover cluster and also offers an option to create an enterprise push node from the active node with a configuration file. Many of the SQL Server services are cluster-aware, such as Analysis Services, Full-Text search, Integration Services, ...

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