Share via

SQL Server on Windows failover cluster

Hafeez Uddin 296 Reputation points
2021-06-03T16:45:41.66+00:00

Is it possible to install the SQL Server 2017/2019 on Windows Failover Cluster using S2D on machine and add second machine to cluster later time for HA?
Two machines are in two different locations.

If I use the AlwaysOn, Do I need to recreate the jobs and ssis packages on the mirror server when I failover?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alex Bykovskyi 2,241 Reputation points
    2021-06-03T17:22:39.213+00:00

    Hey,

    I am not sure if S2D can be deployed on a single machine and be scaled out to a 2 node cluster. You can use alternative shared storage solutions. As an example, StarWind VSAN can be used to deploy a single node cluster. You can scale to a 2 node cluster as soon as you will have additional node available. The only thing, you should run cluster validation after you have both nodes added to the cluster. The following guide covers 2 node cluster configuration:
    https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

    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.

  2. CarrinWu-MSFT 6,891 Reputation points
    2021-06-04T07:34:17.77+00:00

    Hi @Hafeez Uddin ,

    Welcome to Microsoft Q&A!

    If I use the AlwaysOn, Do I need to recreate the jobs and ssis packages on the mirror server when I failover?

    Yes, you need to recreate the jobs and SSIS packages. In SQL Always On synchronizes the individual database part of the availability group. It does not synchronize logins, Agent jobs, SSIS packages, linked servers and server configurations. And this blog may help you to synchronize SQL Server Instance Objects in an Availability Group.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  3. Sojy S N 1 Reputation point
    2021-06-04T16:08:37.523+00:00

    recreate the jobs and SSIS packages. Hope these people can help you out on all MS Azure services, they helped me

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.