Viewing 8 posts - 1 through 8 (of 8 total)
We've had various issues all very similar in nature, never managed to get a root cause. Methods of fixing include -
April 8, 2023 at 7:47 pm
We had a similar issue but it only dropped the AG from one of the replica's recently which was bad enough. Take a read of the following article and see...
April 5, 2023 at 8:42 am
Can I ask why you needed to rebuild the AG's? We had issues where SQL dropped a Primary replica from the AG, the only solution was to drop and recreate...
March 30, 2023 at 10:47 am
We had a very similar issue where the Primary replica was dropped leaving our systems offline. The following article explains the situations that can cause the replica to be removed...
March 30, 2023 at 10:03 am
I tried all the above and I still could not remove the tempdb file. I was trying to fix the issue on an AlwaysOn secondary node and found that I...
June 26, 2020 at 10:36 am
Online index rebuilds could cause the MDF file to grow quickly and leave free space behind once it's completed
December 13, 2019 at 9:10 pm
If I understand you right this should be possible. We have a readable secondary reporting instance with two AGs where the primary replicas for these AGs are both different servers.
December 3, 2019 at 7:33 pm
Thanks, I came to the same conclusion that it must appear as IO on the hidden snapshot. Shame as I normally find the virtual file stats extremely useful.
In the end...
December 3, 2019 at 7:23 pm
Viewing 8 posts - 1 through 8 (of 8 total)