Monthly Archives: February 2012

Help me.. Help you…

Yes, its that time again.  I need your help to help me help you. Its time to vote in the Community Choice section for the SQL Rally PreCons.  I know, if you looked at the abstracts you might be wondering how can I help you? Your not even on the PreCon ballet. That is correct, but here is the kicker. I will be joining my good friend Joey D’Antoni (blog | twitter) with his SQL 2012 and Disaster Recovery–Getting Your Organization Ready session.  I look forward to sharing some HA/DR war stories and demos.

What is Community Choice?

There are two slots still open for SQL Rally 2012 in Dallas and the programming committee wants the community to weigh-in on the final selection. This is a very cool idea and I am glad they are allowing the community to select some all day PreCons.

How can I vote?

If you are a database professional it’s not too late to vote. You can cast your vote here. If you are not a current member of The Professional Association for SQL Server (PASS) you can sign up for a free and then go back to the community choice page to vote.

Voting closes Thursday, February 9th at 5:00pm central time.

Move the Quorum Disk Group

Recently, I worked on a project to migrate data from a four node cluster (3 active, 1 Passive) from an old SAN to a new SAN using SAN Copy by EMC. Once, the data was copied I failed the services around and verified that each service would work on each node. Here is how I moved the quorum disk to each node.

To move the quorum disk group you have to run the command listed below in the command prompt. Make sure you run the command prompt with Administrator rights or you might see an access is denied error.

Cluster group “Cluster Group” /move:<newnode>

If the cluster disk group was active on the db1 node and you wanted to migrate the group to db2 you would use the command below in the command prompt.

Cluster group “Cluster Group” /move:db2

If you like this post check out  my post on renaming the server name for a SQL Cluster or my other cluster posts.