question

NeophyteSQL avatar image
0 Votes"
NeophyteSQL asked ·

sql server cluster

one of the nodes in our cluster had hardware failure

the node cannot be evicted.

if the cluster is destroyed using the destroy cluster option, will the sql server cluster name be lost.

will the applications have to now connect using the actual sql server name as opposed to the virtual name

sql-server-general
10 |1000 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,

the node cannot be evicted.

To recover from the Hardware failure, remove the failed node from the failover cluster using the SQL Server Setup program, address the hardware failure with the computer offline, bring the machine back up, and then add the repaired node back to the failover cluster instance.

More details please refer to following document:
https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/failover-cluster-troubleshooting?view=sql-server-ver15#recovering-from-failover-cluster-failure

·
10 |1000 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 ·

the node cannot be evicted.

The nodes in most cases can be evicted. Use command prompt do not use cluster GUI.

 PS C:\> import-module failoverclusters
 PS C:\> Remove-ClusterNode -Name node_name -Force
 PS C:\> clear-clusternode

Above 3 commands will help you remove cluster node and clear its information. node_name is node name of node which you want to evict.
After you run clear-clusternode it will ask you confirmation and then give YES.

if the cluster is destroyed using the destroy cluster option, will the sql server cluster name be lost.

Again doing this from cluster GUI may not give you proper result, use below command to remove cluster and its copy from all its node and also the object from AD. Its documented

 PS C:\> Get-Cluster -Name Cluster1 | Remove-Cluster -Force -CleanupAD

will the applications have to now connect using the actual sql server name as opposed to the virtual name

If SQL FCI is destroyed by removing it from add remove program you cannot use Virtual name, you have to reinstall SQL Server and then connect.




·
10 |1000 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 ·

I receive an error

you do not have admin proveleges on the cluser

I know I am the admin on the node I am on, the other node is down.

· 1 ·
10 |1000 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.

Share complete error, how are you removing the cluster/node from GUI ? if so launch cluster GUI as administrator.

0 Votes 0 ·
NeophyteSQL avatar image
0 Votes"
NeophyteSQL answered ·

the complete error from powershell says:

you do not have administrative privileges on the cluster, contact your network admin to request access


Do i need domain admin access

· 2 ·
10 |1000 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.

Make sure you start powershell by right click and run as administrator. Like you said you are administrator on machine.

0 Votes 0 ·

I am running as admin, the script executes for ever but the node cant be evicted

the node is completely down and off, is that the problem because the cluster cant even see the node because it is completely broken

0 Votes 0 ·
NeophyteSQL avatar image
0 Votes"
NeophyteSQL answered ·

run as admin

execute the command

nothing happens
it just sits there
node is still there when viewed from cluster manager

· 1 ·
10 |1000 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.

Please give the command you are running and also some screenshot

0 Votes 0 ·
kumarkaushal-1277 avatar image
0 Votes"
kumarkaushal-1277 answered ·

@NeophyteSQL .. Sorry to ask but you said the problem is with one of the Node of the cluster . Then why you want to destroy the cluster ?

Now the node has an hardware failure . That means what ever commands that you are going to execute are from the working node .

If you run the below command from the working node that basically wipes out the Cluster configuration of the NODE from where you are running this commaND . That means if you are running this command on the working server node , You have destroyed the working configuration and data base .

PS C:\> clear-clusternode

@Shashank-Singh ... If you look at the below command you are giving remove-cluster node and giving the node name . But in clear-clusternode you are not passing any Name . That means from which ever node you are running this command it will wipe the cluster configuration of that node .


PS C:\> import-module failoverclusters
PS C:\> Remove-ClusterNode -Name node_name -Force
PS C:\> clear-clusternode

·
10 |1000 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.