Due to an unforeseen hardware error, I had to take our secondary replicas down for maintenance. This was really due to a storage issue and, it was decided at a higher level, to purchase a new storage system for the secondary instance. This is several weeks out from delivery and installation at this point.
This was on a system that also uses FCI with 2 active instances.
I was able to successfully remove the secondary replicas from both Availability Groups and I thought I had done this correctly (they no longer show up in the UI or when I look at the AG Dashboard. However, one one of the AG's, all of my log files are growing. When I query the
sys.databases and look at the
log_reuse_wait_desc for that instance it says
I'd rather not remove the AG as the listener is actively used and would require reconfiguration of numerous
web.configs and other configuration entries. But, I also am slightly worried about the log file growth.
Why, on one AG does it not appear to be growing or have the
AVAILABILITY_REPLICA but on the other it does?