February 16, 2015 at 9:01 am
Hello Everyone
I hope that you all had a very nice weekend.
I am preparing to format the MountPoints on a SQL 2008 Cluster. Currently there are in use databases, logs and index files on these MountPoints. I want to shut down the cluster using the best means possible. I plan to shut down the Cluster and I do not want to Cluster to fail over. I would like to perform this action by using a SQL script. All that I can really find is how to properly do this using SSMS. I can do it that way, but prefer SQL scripts. That way I can keep them handy and use them again. This is not something that I do all the time, so I need some simple hand holding so that I do not mess anything up. After the format of each Mount Point, I will copy the database files, logs and index file back onto the correct mount points, and restart the Cluster. That is my plan. I am fully open to any and all comments and suggestions.
Can anyone suggest or recommend the correct set of steps, in order to completely stop a SQL Cluster?
Thank you in advance for all your time, comments and suggestions
Andrew SQLDBA
February 16, 2015 at 10:54 am
AndrewSQLDBA (2/16/2015)
I am preparing to format the MountPoints on a SQL 2008 Cluster. Currently there are in use databases, logs and index files on these MountPoints. I want to shut down the cluster using the best means possible. I plan to shut down the Cluster and I do not want to Cluster to fail over.
Once you manually take a clustered SQL Server role offline it will stay offline until manually restarted, with this in mind the best way to stop the sql server clustered role is to take the Clustered service offline (will take the agent down too).
Using powershell use
--find service name
Get-ClusterResource | ?{$_.resourcetype -eq "SQL Server"}
--take the service down
Stop-ClusterResource "the sql server resource name"
--to start the clustered instance
Start-ClusterResource "the sql server agent resource name"
AndrewSQLDBA (2/16/2015)
I would like to perform this action by using a SQL script.
How do you expect to stop a service via TSQL from within itself??
AndrewSQLDBA (2/16/2015)
Can anyone suggest or recommend the correct set of steps, in order to completely stop a SQL Cluster?
You don't want to stop the complete cluster role as you'll need access to the disks so they'll need to be online 😉
It is possible to take the complete cluster down and access the disks via the local node but you really need to know what you're doing here, since you're asking these questions implies you don't and it's beyond the scope of a forum post!!
Test this out on a test cluster first If I were you and when you're happy do it for real
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply