Hi Folks, We are back & continuing with the 3rd part of the series. TSQL Exercise on Adventure Works Database part-3 I added collection date as well which can be handy if you want to filter on respective dates. Below is the output As you can see from the above image it contains the current replica and the corresponding Listener Name followed by the fail over date and the most important previous replica information.

The logic is very simple get the data from your central monitoring server using your favorite means (powershell or SSIS) across the estate and load them in to a table. In my organization we have many Availability groups being deployed hence I thought this can be handy. The problem is we don't have history to track them and it is little difficult to gather that information across the estate.

As you know we can find that information from Always ON health session extended events. Many times we need to find when the availability group fail over has happened. Hi Friends, Today I am going to share an article which I think would be useful for many of us.

Restore master database in sql server