I just got Sql Server 2012 AlwaysOn up and running. Everything is working as planned. However, in my production environment, we have applications that create new databases for us. I then have to manually add these new databases to an Availability Group. Is there a way to:
- Have each new DB automatically added to the right group at the time it is created, or
- Run a script periodically that will add any database not already in a group to a group
Thanks!
Scott