Viewing 4 posts - 1 through 4 (of 4 total)
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