Destroy cluster

NeophyteSQL 241 Reputation points
2021-02-28T07:25:17.327+00:00

If i use the option destroy cluster

Will the sql server and the databases still be available to connect to applications or will the sql server intance be wiped out with this option

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,616 Reputation points
    2021-03-01T02:55:39.27+00:00

    Hi @NeophyteSQL ,

    Right-click the wsfc cluster in the Failover Cluster Manager, select More Actions, and then click Destroy Cluster, you will get the following error If the cluster contains any roles.

    You cannot destroy a cluster that contains clustered roles.First delete all clustered roles from this cluster,and then try this action again.

    0 comments No comments

  2. Shashank Singh 6,251 Reputation points
    2021-03-01T08:15:11.87+00:00

    Will the sql server and the databases still be available to connect to applications or will the sql server intance be wiped out with this option

    Assuming you have removed all the roles then yes if you destroy WSFC there would be nothing left.

    then how to make this a stand alone server instance and just evict the node completely that is not working

    To do this you have to first evict the nodes and destroy cluster completely. GUI also has option to destroy existing cluster. After this you have to rebuild the standalone server from scratch.

    0 comments No comments

  3. NeophyteSQL 241 Reputation points
    2021-03-01T20:54:01.12+00:00

    then how to make this a stand alone server instance and just evict the node completely that is not working

    I want to make this a stand alone server instance and ensure nothing is wiped out. please help