February 25, 2014 at 6:15 am
Hi,
How to find when (date/time) a database was last removed from AlwaysOn Listener?
Is there any query (DMV) to find the details easily?
Thanks.
February 26, 2014 at 2:24 am
SQL-DBA-01 (2/25/2014)
Hi,How to find when (date/time) a database was last removed from AlwaysOn Listener?
Is there any query (DMV) to find the details easily?
AlwaysOn databases are bound to an AlwaysOn group, not a listener.
AlwaysOn listeners are bound to and AlwaysOn group, not a database.
This link details AlwaysOn catalogs in SQL Server, this link details AlwaysOn DMVs in SQL Server
If a database is removed from an AO group, there's unlikely to be any record of this in the catalogs since rows containing information on an AO joined database are removed.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply