We currently have a 2 node dev cluster which I need to dismantle and either keep only node 1 or move to a new server. I am an SQL noob and this is a good project for me to dip my toes into the SQL reality.
I looked around for some info online but did not find anything specific so I am reaching out for help, advice and guidance.
Here is some tech info. If more is needed I will gladly provide
SQL Server 2014 on servers running 2012 r2
2 nodes CANMTLDEVSQL1 ip 10.240.201.137 and CANMTLDEVSQL2 10.240.201.139 running a server called DEVSQL ip 10.240.201.182.
CANMTLSQL2 is shut down and all is running on CANMTLDEVSQL1
We want to get rid of CANMTLDEVSQL2 can anyone please suggest a good way to go about doing this?