Could I convert cluster(ASCS) to standalone CI(w/ ms) in emergency?

[former_member211576]

Hi experts,

   I install WSFC and SQL server 2012 AlwaysOn - non shared disk cluster. Let's assume quorum lost or CNO lost or AD down and I would like to start SQL server 2012 on physical server without AG listener and SAP without ASCS.

  I am thinking a workaround like this. I change DVEBMGS01 profile to run additional message server and enqueue server in emergency and connect to physical SQL server without AGlistener. Does this work? Is there any documents which mention this?

[former_member218805 · Accepted solution]

Hi Dennis,

I'm afraid that is not possible.

The scenario you described is a change from HA to Distributed/Central system. That is only possible by doing a system copy, as described in the System Copy Guides.

Best Regards,

Alessandro Parolin