O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

How WSFC Sets the Stage for SQL Server Clustering

Figure 42.5 shows an Excel spreadsheet that documents all the needed Internet Protocol (IP) addresses, network names, domain definitions, and SQL Server references to set up a two-node SQL Server failover clustering configuration (configured in an active/passive mode).

Image

FIGURE 42.5 An Excel spreadsheet for a two-node active/passive SQL failover cluster configuration.

USPETSDSQLTST01 is the first node, USPETSDSQLTST02 is the second node, and the cluster group name is USPETSDSQLCLUST (simple naming is used here to better illustrate the point). And the cluster network name is Cluster Network 1. This ...

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