December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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).
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 ...