locked
SQL 2012 Failover Cluster Creation RRS feed

  • Question

  • Hi

    I'm build a SQL 2012 Cluster using Windows Server 2012.

    Simple question, do I need to create a failover cluster on the OS first or will the SQL installation do this for me?

    Cheers

    Z

    Friday, July 26, 2013 4:05 PM

Answers

  • Clustering is basically windows feature and sql server utilizes this feature and works on it.So you have to first create windows cluster i.e you OS cluster  then on top of that you have to create SQL cluster 

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621MVP Friday, July 26, 2013 5:56 PM added OS cluster
    • Proposed as answer by Fanny Liu Saturday, July 27, 2013 7:05 AM
    • Marked as answer by Fanny Liu Wednesday, July 31, 2013 12:23 PM
    Friday, July 26, 2013 5:56 PM
  • Here's a step-by-step process (with screenshots) outlining how you can create a SQL Server 2008 Failover Cluster on Windows Server 2008. The same concepts apply on Windows Server 2012 with SQL Server 2012


    Edwin Sarmiento SQL Server MVP
    Blog | Twitter | LinkedIn

    • Proposed as answer by Fanny Liu Saturday, July 27, 2013 7:05 AM
    • Marked as answer by Fanny Liu Wednesday, July 31, 2013 12:23 PM
    Friday, July 26, 2013 6:19 PM

All replies

  • Clustering is basically windows feature and sql server utilizes this feature and works on it.So you have to first create windows cluster i.e you OS cluster  then on top of that you have to create SQL cluster 

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621MVP Friday, July 26, 2013 5:56 PM added OS cluster
    • Proposed as answer by Fanny Liu Saturday, July 27, 2013 7:05 AM
    • Marked as answer by Fanny Liu Wednesday, July 31, 2013 12:23 PM
    Friday, July 26, 2013 5:56 PM
  • Agree with Shanky, You need to create cluster at windows first.

    In Windows Server 2012 go at tool and with the help of fail over cluster manger create cluster.

    Friday, July 26, 2013 6:04 PM
  • Here's a step-by-step process (with screenshots) outlining how you can create a SQL Server 2008 Failover Cluster on Windows Server 2008. The same concepts apply on Windows Server 2012 with SQL Server 2012


    Edwin Sarmiento SQL Server MVP
    Blog | Twitter | LinkedIn

    • Proposed as answer by Fanny Liu Saturday, July 27, 2013 7:05 AM
    • Marked as answer by Fanny Liu Wednesday, July 31, 2013 12:23 PM
    Friday, July 26, 2013 6:19 PM