AlwaysOn Listener/New Database Creation

Question

Hello-

Just reading up on AlwaysOn and wondering how new DBs are provisioned relative to the AG Listener.  Many applications handle the DB creation during their install process by providing a SQL Server, and credentials.  Can the AG listener name be used in this same capacity, with the DB then being added to that AG?

Or do i have to use the traditional route of providing an actual SQL node name, adding the DBs to the AG and then reconfigure the application to use the Listener name.

Thanks in advance!

roc

Answer 1

Creating a database while connected through an AG Listener does not automatically add the new database to the AG and make it available on all the nodes. 

David

---

David http://blogs.msdn.com/b/dbrowne/

Answer 2

Hello,

It seems that you had create a Always On Availability Group with a availability group listener, and then you create a new database which allow application connect to.

Just as David post above, the new created database had not been added to the availability group automaticlly. But you can add the database to the existing AlwaysOn availability group by using SQL Server Management Studio, Transact-SQL, or PowerShell.

Reference:http://technet.microsoft.com/en-us/library/hh213078.aspx

Regards,
Fanny Liu

---

Fanny Liu
TechNet Community Support