Long story short. The transaction log is getting bigger even though there's daily full backup and hourly log backup running. I decided to change the recovery mode to SIMPLE and shrink the transaction log file. However, I'm getting the following error every time I try to shrink the log file using DBCC SHRINFILE(LOGICAL FILE NAME, Target Size). Can you help please? It's a production issue.
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). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.