How to validate Cluster configuration on window 2008 server

It’s good to perform cluster validation tests on window server 2008 environment whether using existing cluster setup or new one. Cluster validation wizards will help to validate your cluster environment. It used to perform all cluster configuration, system configuration, network and storage related tests to validate your cluster. Using cluster validation wizard, you can troubleshooting ...

Add new disk to sql server 2008 cluster

We have gone through previous article that tells you, how to add new disk in Sql server 2005 cluster environment. Here you will see, step by step approach to add new disk in Sql server 2008 failover cluster environment. Steps are very much similar to sql server 2005 cluster. First thing you need to ask your SAN ...

How to move cluster resources from one node to another

After sucessful configuration of Active/passive cluster in sql server 2008, first thing you have to do is check the sql service cluster failure whether its working fine as per expection or not. To do so you can use either Failover Cluster Manager or command prompt. By using “Failover cluster manager” Click on Start -> Administrative ...

Uninstall sql server 2008 R2 cluster instance

Lots time we have done installation of sql server instance as well as removed unwanted instance from server. As a DBA some time we have to uninstall sql server cluster instance, actually uninstalling a clustered instance of sql server is any easy task to do. It always recommended to perform any task first on non production cluster (UAT) server.  ...

Error HRESULT-0x80071736 in sql server 2008 R2

While installation of sql server 2008 r2 on window cluster environment, we came across very strange situation with below error  that says “ The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)”. Now to find out the reason of failure, we gone through the ...

How to configure MSDTC in sql server 2008

 Microsoft Distributed Transaction coordinator (MSDTC) combines different data source of client application into one transaction and maintains transaction integrity like (ACID properties) while communicating with the server. Here, whatever request or transactions raise client application goes to resource manager asking about to manage data and work using MSDTC. In this process, Microsoft Distributed Transaction coordinator ...

Installation of MS Sql Server 2008 on Windows 2003 cluster 1

you might come across activity like sql server 2008 cluster installation on windows 2003 cluster. Before installation of sql server 2008 cluster, you have to make sure that all required permissions has been given to sql service account. Important things can be monitor by using below pre and post checklist. Follow instructions pre and post ...

SQL Server Cluster Installation Pre-Checklist 1

As SQL Dba, you might come across activity like sql server cluster installation on windows 2003 cluster. Before installation of sql server cluster you have to make sure that all required permissions has been given to sql service account.  Also you have to take care some important things like both nodes are accessible or not. ...

How to add share disk in SQL Resource Group

After doing the capacity planning for the SQL Cluster Server, we decided to add the some more space on production server. Our production server is built in cluster environment with windows server 2003 and sql server 2005 cluster. Request raise to Windows Admin team to add the physical disk of 100 GB size in cluster ...

How to install service pack or hotfix on failover cluster

On cluster environment applying service pack or hotfix is different compare to stand alone sql server. Now question is How to install service pack on sql server 2005 and 2008 in failover cluster? For this activity, we have to perform some extra steps on failover cluster that are explain in this article. How to install Sql server ...