locked
types of cluster in ms sql server 2012 RRS feed

  • Question

  • Hi,

    I am not good in sql server, i got one requirement to migrate standalone ms sql server(which contains replications also) to cluster env, so i have few things to know

    1) what are the types of cluster available in ms sql server 2012

    2) any steps would be appreciated

    BR

    PGR  

    Wednesday, February 11, 2015 10:38 AM

Answers

  • Hi PGR,

    Firstly, there are two types of clustering: Active/Active or Active/Passive. 

    In an Active/Active cluster there will be two or more nodes, each one “owning” an instance of Microsoft SQL Server. If one node fails, the instance it owns would fail over to the other node, running alongside (and contending for resources with) the other instance. Each copy of SQL Server acts independently. 

    If one of the SQL Servers in the cluster should fail, then the failed instance of SQL Server will failover to the remaining server. This means that both instances of SQL Server will be running on one physical server, instead of two. 

    In an Active/Passive setup, at least one node is not the owner of an instance of SQL Server. It is “passive” and only exists to accept a failover of a node hosting a SQL instance in the event of a failover. For more details, please review this blog: SQL Server Clustering.

    Secondly, you can follow the steps in this blog to move SQL Server from standalone to Cluster environment.


    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support




    Thursday, February 12, 2015 2:21 AM

All replies

  • Hello

    I believe you want to have a 2 node active-passive failover cluster. 

    Please follow below step-by-step guide to setup the cluster (I recommend Windows Server 2012 R2)

    https://technet.microsoft.com/en-us/library/cc731844%28v=ws.10%29.aspx

    After you have the windows cluster up and running you can install SQL 2012 in cluster

    https://msdn.microsoft.com/en-us/library/hh231721.aspx

    Regards


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Wednesday, February 11, 2015 1:00 PM
  • Hi PGR,

    Firstly, there are two types of clustering: Active/Active or Active/Passive. 

    In an Active/Active cluster there will be two or more nodes, each one “owning” an instance of Microsoft SQL Server. If one node fails, the instance it owns would fail over to the other node, running alongside (and contending for resources with) the other instance. Each copy of SQL Server acts independently. 

    If one of the SQL Servers in the cluster should fail, then the failed instance of SQL Server will failover to the remaining server. This means that both instances of SQL Server will be running on one physical server, instead of two. 

    In an Active/Passive setup, at least one node is not the owner of an instance of SQL Server. It is “passive” and only exists to accept a failover of a node hosting a SQL instance in the event of a failover. For more details, please review this blog: SQL Server Clustering.

    Secondly, you can follow the steps in this blog to move SQL Server from standalone to Cluster environment.


    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support




    Thursday, February 12, 2015 2:21 AM
  • Also, you can practice from this link

    http://blogs.msdn.com/psssql/archive/2009/07/15/how-to-test-drive-sql-server-clustering-for-free.aspx  --Set up cluster without money


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, February 15, 2015 8:11 AM