• 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" 😉