One day, I found a db transaction log file growing so big which is also in AG. I couldn't understand why because full backup and transaction log backup running fine. I took a extreme measure which was to remove the db from AG, switch it to SIMPLE mode and shrink the transaction log file. When I try to shrink the log, I get the error like below. I ran a qeury against sys.databases and found a record with the db and AVAILABILITY_REPLICA, which indicates there's unfinished transaction n AG. Can you help with shrinking the transaction log without getting the error below?
Error: The log scan number (202388:69632:1) passed to log scan in database is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).
- This topic was modified 2 years, 4 months ago by chulheekim.