O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

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

Clustering with RAC

Clustering is ideal for two or more servers that have shared resources, such as disks. In case of a hardware failure on one server in the cluster, the other servers can pick up the workload until that server can be brought back up.

SQL Server clustering is dependent on operating system clustering. The file systems that SQL Server uses for the datafiles need to be on a clustered shared disk, and the software is installed on all of the nodes of the cluster. The SQL Server instance can be active on only one node (server) at a time, but there can be other SQL Server instances active on other nodes. Active/passive clustering is when one SQL Server instance is installed on the cluster and running on one node, and the second node ...

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