Share via

Is it possible to 'de-cluster' a SQL Instance?

Anonymous
2020-10-20T20:40:47+00:00

Hi,

I have a 2-node SQL 2014 clustered instance running on Server 2012 R2.

For various reasons we would like to 'de-cluster' it i.e. turn it into a regular stand-alone instance. Is it possible to do this without having to build a separate instance?  Can the cluster be removed and the SQL instance left standing?

Thanks,

Mark

Windows for home | Other | Apps

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-10-20T20:58:57+00:00

    Hi mcai9mh3, I am Rob, an independent and a 15 time and dual award MVP specializing in Windows troubleshooting and Bluescreen analysis. Please remember as independents we are not responsible for the development of Windows or the computer hardware and drivers. If you will work with me I will be here to help until the issue is resolved.

    The Microsoft Community only supports the Windows Home and Pro for Consumer users and has no information to help with SQL Server issues.

    SQL Server and other Windows Server versions are supported via

    Microsoft's Q&A and TechNet Forums so best to check with the

    Experts at those locations. (Those are the Official Microsoft Support

    Forums for SQL Server.)

    Microsoft's Q&A - SQL Server Forums - Free

    https://docs.microsoft.com/en-us/answers/produc...

    TechNet - SQL Server Forums - Free

    http://social.technet.microsoft.com/Forums/en/c...

    TechNet - Windows Server (Server 2008 R2 Forums are locked so

    you will need to use the other forums for current support)

    http://social.technet.microsoft.com/Forums/en/c...

    TechNet - Windows 10 IT Pro - Forums - Free

    https://social.technet.microsoft.com/Forums/win...

    TechNet- Forums

    http://social.technet.microsoft.com/Forums/en/c...

    TechNet - Where is the Forum For…?

    http://social.technet.microsoft.com/Forums/en/w...

    Application development and programming - MSDN - SQL Server Forums.

    MSDN - SQL Forums - Free

    http://social.msdn.microsoft.com/Forums/en/cate...

    Here to help,

    Rob

    Standard Disclaimer: Those may be non-Microsoft websites. The pages appear to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

    Please let us know the results and if you need further assistance. Feedback definitely helps us help all.

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more