Whether external user will be replicated to DR database automatically?

WisonHii 81 Reputation points
2023-05-02T03:20:01.72+00:00

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?

Thanks

Azure SQL Database
{count} votes

Accepted answer
  1. Alberto Morillo 33,866 Reputation points MVP
    2023-05-02T04:31:24.3833333+00:00

    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

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.