Comments for Ryan Adams Blog

Comment on How to move the Model Database by Jose Rivera

Jose Rivera — Fri, 10 Feb 2012 17:21:29 +0000

Thanks!!!

That clears my biggest question…

Comment on How to move Cluster MSDTC Drive by Ryan Adams

Ryan Adams — Thu, 09 Feb 2012 18:58:51 +0000

Only if you have to reboot to present the new drives/LUNS to the OS. You also cannot circumvent that by moving the MSDTC to a passive node, or it won’t work when a failover occurs.

Comment on How to move Cluster Quorum Drive by Ryan Adams

Ryan Adams — Thu, 09 Feb 2012 18:51:24 +0000

I would always do something like this during a planned outage.

Comment on How to move the Model Database by Ryan Adams

Ryan Adams — Thu, 09 Feb 2012 18:47:31 +0000

If you shutdown or restart the SQL Service in cluster manager then the service will do just that. It is intentional and not a failure of the service so it will not get moved over to another cluster node. If you told it to move the service in cluster manager, then yes it would get moved to another node.

Comment on How to move the Master database by Ryan Adams

Ryan Adams — Thu, 09 Feb 2012 18:42:52 +0000

You need to verify in Cluster Manager which node the SQL services are running on and also verify that they are running. Run configuration manager from that node.

Comment on How to move Cluster MSDTC Drive by Brad

Brad — Mon, 30 Jan 2012 16:59:34 +0000

Do any cluster resources need to go offline for this reconfiguration? Such as the SQL services?

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?