compdigit44
asked on
Cluster SQL 2012 Service Question
I have to move some DB's on my SQL cluster and have the following question..
If I connect to the primary node and place the SQL service in the cluster offline then outside of Failover cluster will I be able to open and do work in SQL management studio?
If I connect to the primary node and place the SQL service in the cluster offline then outside of Failover cluster will I be able to open and do work in SQL management studio?
To the question I think you're asking (can you connect to a clustered SQL instance when it's offline in cluster manager?), the answer is no - you can only connect if it's online. The clustered instance of SQL lives on only one node at any given time, and when you connect to the name, you'll be directed to whichever node happens to own the instance at that time.
When you're administering the instance, it acts like any other instance - you can detach/reattach database files, backup/restore, and perform admin tasks just like any other non-clustered instance - normal database management tasks work transparently the same through SSMS.
Given that, if you want to move the data files to a new location, just do it as you normally would (as long as you stay on the same disk). If you want to change disks, ensure it's moving to a cluster shared drive that's owned by the same application group in cluster manager, and that the SQL Server service has a dependency on that drive in cluster manager.
When you're administering the instance, it acts like any other instance - you can detach/reattach database files, backup/restore, and perform admin tasks just like any other non-clustered instance - normal database management tasks work transparently the same through SSMS.
Given that, if you want to move the data files to a new location, just do it as you normally would (as long as you stay on the same disk). If you want to change disks, ensure it's moving to a cluster shared drive that's owned by the same application group in cluster manager, and that the SQL Server service has a dependency on that drive in cluster manager.
ASKER
Thank you for your response...
Here is my question if I take the clustered instance of SQL offline via FailOver manager would I still be able to open and use management console directly on the node which host all of the SQL services???
Here is my question if I take the clustered instance of SQL offline via FailOver manager would I still be able to open and use management console directly on the node which host all of the SQL services???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or are the drives you want them to move to not in the cluster?
Each node in the cluster should have it's own SQL Server Service, but only one should be running at a time. SQL Server Management Studio should be able to connect to clustered SQL Service instance using ClusterName\InstanceName or if it isn't a named instance then just by the ClusterName. If SSMS can't connect then the SQL Server wasn't installed correctly.