CODEWITHSUNDEEP
sql-serveralwaysonavailability
B.Kingsun
B.Kingsun

Reputation: 370

How to add a database in the AG Listener SQL server and both created on the primary and secondary SQL Servers?

I have builded up A and B as an AG(Availability Groups) with a listener(such as the DNS name is LSN) and connected to the SQL Server with the account LSN.

Now when I creating a database in LSN , the database only created in the A which is Primary AG and nothing happened in B ,the Secondary one.

How can I make it both created in the same time?

Upvotes: 0

Views: 566

Answers (1)

TheGameiswar
TheGameiswar

Reputation: 28938

How can I make it both created in the same time?

It seems you have misunderstanding of AG groups.AG groups replicate database level transactions once you add a database to availabilty group

There is no technology which which will replicate create database statement on secondary(further which is read only)

Upvotes: 1

Related Questions