Active/Passive to single node SQL cluster.

• swetha.sql1

  SSC Enthusiast

  Points: 172

  More actions

  March 14, 2017 at 3:19 pm

  #401787

  Hi All,

   We have SQL 2008 Active/Passive cluster .Our plan is to retire one node of the cluster and convert it to a single node SQL cluster.
   Our plan is to remove one node of the cluster and convert it to a single node SQL cluster.

  In addition Reporting services is installed and running . some reports are there.

  EVICT the node is solution to this and remove the node from Quorum as well.

  But my question is:

  Do i need to take care any another things before? Any links ? Any recommendations

  Thanks in Advance.

  Regards,
  Swetha Vemisetti

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  March 23, 2017 at 7:01 am

  #1934502

  remove the node from the clustered instance by using the installer, then evict the node from the cluster.

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"