Best Practice for AlwaysOn and FCI

Vishu 1,556 Reputation points
2021-09-09T14:23:52.617+00:00

Experts , Can you please help share best practices for implementing AlwaysOn Availability Group and FCI for SQL 2019

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,265 questions
0 comments No comments
{count} votes

Accepted answer
  1. YufeiShao-msft 7,081 Reputation points
    2021-09-10T07:34:28.737+00:00
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Alex Bykovskyi 1,841 Reputation points
    2021-09-11T17:28:52.897+00:00

    Hey,

    Just adding more information.
    Check the following article to understand FCI and AG and how you can use them together:
    https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server?view=sql-server-ver15

    The following guide will walk you through the configuration process of the FCI:
    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

    0 comments No comments