Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there any way to 'de-cluster' an instance of SQL Server 2012 that was installed using the 'New SQL Server Cluster Installation' option? We are having issues with the failover portion of clustering services and since we did not implement the cluster (and really there is no need) we would like to turn this into a stand-alone installation. Removing the Windows Clustering portion just took SQL down with it. All help and insight is appreciated, thanks!

share|improve this question

1 Answer 1

You need to do this through the installer. Choose remove node from cluster in the SQL Server installer.

http://msdn.microsoft.com/en-us/library/ms191545.aspx

share|improve this answer
    
Would this also remove the 'named' cluster portion? We have the one default instance right now that is handling all traffic using an alias. –  Ddono25 Aug 30 '12 at 18:30
1  
I believe it would leave you with a single-node cluster that bears the name of the cluster. From there, you would evict the node that you just removed from the cluster. Then you could install a separate instance on that piece of hardware. –  swasheck Aug 30 '12 at 18:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.