question

NeophyteSQL avatar image
0 Votes"
NeophyteSQL asked Shashank-Singh commented

Destroy cluster

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Shashank-Singh avatar image
0 Votes"
Shashank-Singh answered Shashank-Singh edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NeophyteSQL avatar image
0 Votes"
NeophyteSQL answered Shashank-Singh commented

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
There is no way to directly convert SQL Server FCI to a stand-alone instance of SQL Server. You need to install a stand-alone instance and migrate the data.Then remove the failover cluster instance.

0 Votes 0 ·

See my updated answer

0 Votes 0 ·