We have Sql Server 2016 and set up Always ON with 2nd replica (Primary and Secondary) Currently looks like Log file filling up, getting disk pace full. I tried to resume the secondary database which was in Not Synchronizing/Suspect status after adding disk space and worked fine for 1 day and again it's starting to fill up the space and we are out of disk space. We have Primary is still Synchronized. We are running log backup every 15 minutes on Primary. I tried to Shrink the Log file but getting following error: Cannot shrink log file 2 (SQL1_log) because the logical log file located at the end of the file is in use.
- When I ran SELECT name, log_reuse_wait_desc FROM sys.databases
Other Databases showing log_reuse_wait_desc = "Nothing" except my Primary DB showing " AVAILABILITY_REPLICA"
DBCC LOGINFO Shows lot of almost (1000+) VLF files with Status = 2
When I am running OPEN TRAN ==> Nothing getting any Blocking/Open Session ID so I can't Kill anything
Thank you in Advance for your help!