i have multiple databases in one SQL managed instance, i wish to replicate only one the databases instead of all of them

Question

I have multiple databases in my SQL managed instance, when create a failover group all the databases are replicated to failover group, instead i want only selective databases to be replicated.

Answer 1

Hi Jayesh Lakhiani,

Greetings!As I understand, you want to create a failover group but only replicate specific databases, not all of them.

Unfortunately, Azure SQL Managed Instance's failover groups replicate all user databases by default, and selective database replication within a failover group isn't supported directly.

To achieve selective replication, you can consider the following approach:

• Create Multiple Managed Instances: Set up separate managed instances for the databases you want to replicate and those you don't.
• Configure Failover Groups: Create failover groups for the managed instances that contain the databases you want to replicate.

This way, you can control which databases are included in the failover group by placing them in different managed instances.

For more information, please refer the document: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-sql-mi?view=azuresql

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.