Tuesday, April 20, 2010

Checking The SQL Server 2005 Installation From Cluster Administrator

Once an instance of SQL Server 2005 clustering is installed, you can view its cluster resources by going to Cluster Administrator and opening up the SQL Server Group resource, as shown below.


The above figure shows the cluster resources for the SQL Server 2005 cluster. We see all of the names of the resources, their state, and which node the resources are running on. 


Cluster Administrator is a great tool for seeing if all the resources are up and running and which node is the current active node.
Here is a brief rundown on each of the SQL Server 2005 cluster resources:

1.   Disk F: This is the shared disk array where the SQL Server data files and logs are stored.

2.   SQL Network Name (sqlcluster): This is the virtual SQL Server name used by clients to connect to this clustered instance of SQL Server 2005. The name "sqlcluster" is the name I have assigned this cluster instance, and will not be the same as your cluster, unless you name yours the same as mine. 

3.   SQL IP Address (sqlcluster): This is the virtual SQL Server IP address used by clients to connect to this clustered instance of SQL Server 2005. Again, the name "sqlcluster" is the name of the virtual server, and is the one I have used for this cluster. Your name will most likely be different. 

4.   SQL Server: This is the SQL Server service. 

5.   SQL Server Agent: This is the SQL Server Agent service. 

6.   SQL Server FullText: This is the SQL Server FullText service. Even though you may not use this service, it is automatically installed as a cluster resource.
data base administrator. Microsoft database administrator. sql questions and answers. interview questions for servers. database administrator interview questions. sql dba interview questions and answers. server interview. sql questions for interview. ms sql interview questions with answers. becoming a database administrator. server interview tips. SQL Server cluster installation, step by step guide to install cluster services, sql server 2012 cluster installation, sql server 2008 cluster installation, sql server 2008 r2 cluster installation, sql cluster per-requisites, cluster interview question and answers, sql server cluster interview question and answers, cluster configuration, cluster fail over, cluster failover, cluster fail back, cluster fail back, cluster in sql server 2005, sql server 2000 cluster, sql server 2005 cluster, sql server 2008 cluster, cluster installation, windows server 2008 r2 cluster, windows cluster installation, windows cluster prerequisites, Step By Step Guide To Configure SQL Server Failover Cluster, step by step cluster configuration, step by step images guide for cluster, cluster installation with screenshots

0 comments:

Post a Comment