SQL server cluster

Hussain Bazzar 21 Reputation points
2021-02-15T06:58:09.077+00:00

what are the steps to create a cluster in SQL with a different subnet?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,068 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Olaf Helper 42,386 Reputation points
    2021-02-15T07:24:29.053+00:00

    Cluster is mainly a Windows feature, SQL Server is just a cluster-aware service.
    And Clustering a wide subject, start with some tutorials to get started.

    See for example Create a failover cluster

    0 comments No comments

  2. Shashank Singh 6,246 Reputation points
    2021-02-15T08:58:13.03+00:00

    what are the steps to create a cluster in SQL with a different subnet?

    You are referring to multi subnet cluster. I could easily find MSSQLTIPS blog

    sql-server-2012-multisubnet-cluster-part-1

    0 comments No comments

  3. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2021-02-16T02:37:23.877+00:00

    Hi @Hussain Bazzar ,

    > what are the steps to create a cluster in SQL with a different subnet?

    Please read below documents to get detail steps.

    Installing and Configuring a SQL Server 2014 Multi-Subnet Cluster on Windows Server 2012 R2
    SQL Server Multi-Subnet Clustering (SQL Server)


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments No comments

  4. Alex Bykovskyi 1,831 Reputation points
    2021-02-17T19:08:39.83+00:00

    Hi,

    The following guide will walk you through the Multi-Subnet Cluster configuration process:
    https://www.starwindsoftware.com/resource-library/installing-and-configuring-sql-sever-2014-multi-subnet-cluster-on-windows-server-2012-r2/

    Cheers,

    Alex Bykovskyi

    StarWind Software

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    0 comments No comments