tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P73

Microsoft SQL Server 2008 R2 Unleashed- P73:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 664 CHAPTER 21 SQL Server Clustering FIGURE An Excel spreadsheet for a two-node active passive SQL Cluster configuration. The cluster controls the following resources Physical disks Q is for the quorum disk S is for the shared disks and so on. The cluster IP address The cluster name network name The Distributed Transaction Coordinator MSDTC The SQL Server virtual IP address The SQL Server virtual name network name SQL Server SQL Server Agent The SQL Server Full-Text Search service instance if installed After you successfully install configure and test your cluster MSCS you are ready to add the SQL Server components as resources to be managed by MSCS. This is where the magic Download from Installing SQL Server Clustering 665 happens. Figure shows how the Cluster Administrator should look after you install configure MSCS. It doesn t have SQL Server 2008 installed yet. FIGURE Windows 2003 Cluster Administrator showing managed resources prior to installing SQL Server. 21 Installing SQL Server Clustering When you install SQL Server in a clustered server configuration you create it as a virtual SQL Server. A virtual SQL Server is not tied to a specific physical server it is associated with a virtualized SQL Server name that is assigned a separate IP address not the IP address or name of the physical servers on which it runs . Handling matters this way allows for your applications to be completely abstracted away from the physical server level. Failover clustering has a new workflow for all Setup scenarios in SQL Server 2008. The two options for installation are Integrated installation This option creates and configures a single-node SQL Server failover cluster instance. Additional nodes are added by using the Add Node functionality in Setup. For example for Integrated installation you run Setup to create a single-node failover cluster. Then you run Setup again for each node you want to add to the cluster. Advanced Enterprise installation .