SSIS on Basic Availability Group

Question

I have a SQL Server which is running with Standard Edition in one data center. I want to configure Always On (Basic Always On because of standard edition) for SSISDB with DR node in another data center (different subnet).

1. Is it possible to Setup Basic Availability group for SSISDB?
2. What will be the limitations?

Thank you!

Answer 1

Hi @Prince Kumar Rastogi ,

1.Is it possible to Setup Basic Availability group for SSISDB?

What is your current version? Starting from SQL Server 2016, you can add SSISDB as Availability Database in Always On Availability Group (AG). This enables high availability and automated failover for SSISDB. Please reference: step-by-step-guide-to-add-ssidb-to-alwayson-ag

2.What will be the limitations?

If the SQL Server resources fail over as part of a cluster failover, the running packages do not restart. You can use checkpoints to restart packages. For more information, see Restart Packages by Using Checkpoints.

More information : basic-availability-groups-always-on-availability-groups, ssis-catalog

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Prince Kumar Rastogi ,

...Is Multi Subnet Failover allowed/supported under Basic Availability Group?

Yes. It is.

Availability groups support a multi-subnet environment, that is, availability replicas can be in different subnets. No matter it is one basic AG or High AG.

More information: sql-server-multi-subnet-clustering-sql-server

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Hi @m

Current version of SQL Server is : SQL Server 2019 (Standard Edition)

Is Multi Subnet Failover allowed/supported under Basic Availability Group?

Thank you!