768
Part V: Enterprise Data Management
Summary
In this chapter, you learned that High Availability of a SQL Server 2012 instance is
achieved through Clustering. Although achieving 100% uptime is virtually impossible,
Clustering allows you to maintain a consistent service level guarantee close to 100%
uptime, sometimes expressed as “fi ve 9s” or 99.999%.Clustering works by constantly checking for responsiveness of clustered nodes, drives,
IP addresses, network names and other objects. If no response is detected within the
default or confi gured thresholds, failover of SQL Server instance to another clustered node
initiates.To install SQL Server 2012 as a Clustered instance you fi rst confi gure Windows Server for
Clustering by setting up network confi gurations for public and private communications,
adding necessary server roles and services to support the Failover Clustering feature. A
Windows Cluster is created using the Failover Cluster Manager and following the Cluster
Wizard.After Windows Server is confi gured for Clustering, you install SQL Server 2012 as a
Clustered instance from the SQL Server 2012 Installation Center option Add Node to a SQL
Server Failover Cluster.c29.indd 768c29.indd 768 7/31/2012 9:52:03 AM7/31/2012 9:52:03 AM
http://www.it-ebooks.info