Comments for Ryan Adams Blog

Comment on How to move Cluster Quorum Drive by Jose Rivera

Jose Rivera — Fri, 27 Jan 2012 19:00:33 +0000

So, this process can be executed while the cluster is up and running during normal hrs or do I need to do it during a planed outage time?

Comment on How to move the Model Database by Jose Rivera

Jose Rivera — Fri, 27 Jan 2012 18:13:53 +0000

By shut down I meant while restarting.

Comment on How to move the Model Database by Jose Rivera

Jose Rivera — Fri, 27 Jan 2012 18:13:13 +0000

If you are doing this on a Cluster environment wont the passive server try to take control when the SQL Server is shut down?

Comment on How to move the Master database by Jose Rivera

Jose Rivera — Fri, 27 Jan 2012 13:34:29 +0000

Thanks for your quick reply. This is the first time I am doing this movement. We are planning for outage in 2 weeks. So, I am building a document on preparation for the move of the system files to new and faster disks.

Forgot to mention. My SQL01 is my preferred owner and it is actually running. SQL01 is where I cant see the SQL Server Services when I go to Config Manager. Yes, I was expecting to see the services running but there is none.

SQL02 is the failover server. This is where I can see all the services and all services are stopped.

Any ideas?

Comment on How to move the Master database by Ryan Adams

Ryan Adams — Thu, 26 Jan 2012 21:48:39 +0000

It’s probably because the services are running on the other node. Log into the other node and open Configuration Manager from there. Alternately, you could use cluster manager and move the services group from the other node to the one you are on.

Comment on How to move the Master database by Jose Rivera

Jose Rivera — Thu, 26 Jan 2012 19:45:45 +0000

When I go to the SQL Server Configuration Manager, and I select the SQL Server Services, I am not able to see the SQL Server Service or anything else. It is actually empty.

My nodes are SQL01 & SQL02, but the actual global (UNC) name is SQLPROD.

Why I cant see the SQL Server Service? Do I need to stop the cluster process before I try to change the parameters on the SQL Server Service?

Comment on SQLCruise: The Trident by Steve Jones

Steve Jones — Thu, 26 Jan 2012 17:57:10 +0000

Enjoy! Sounds like it should be a good time.

Comment on SQLCruise: The Trident by Andy Galbraith (@DBA_ANDY)

Andy Galbraith (@DBA_ANDY) — Thu, 26 Jan 2012 16:52:05 +0000

Jealous! Have fun! {-:

Comment on SQLCruise: The Trident by SQLAmyM

SQLAmyM — Thu, 26 Jan 2012 15:54:14 +0000

Thanks for the great shout out to Idera. It’s our pleasure to not only serve the community, but to host the contest and send you guys on this great opportunity for training and quality time with your wife! Happy sailing!

Comment on How to move the Master database by Ryan Adams

Ryan Adams — Wed, 11 Jan 2012 23:00:32 +0000

You are going to have to be much more specific. What are you doing when you get that error? Did you look in the event log and error log to see what you found?