Whether external user will be replicated to DR database automatically?

WisonHii 81 Reputation points

Here is one Azure SQL Database, and it has one Geo-replica database.

If I create one user in primary database, whose type is EXTERNAL_USER from Azure Active Directory, whether the user will be replicated to DR database automatically?


Azure SQL Database
{count} votes

Accepted answer
  1. Alberto Morillo 32,011 Reputation points MVP

    Logins that were created at the server level (master database) and then were used to create users at the database level, you will find the users are replicated, but the server login (at the master database) won't exist on the secondary region and will have to be manually recreated on the logical server at the secondary region.

    However, contained database users are replicated and exist on the secondary replicas of user databases.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful