Here's more update. The full backup failed with the similar error message like below. Now, my focus is switched to get the full backup working instead of getting the transaction...

I don't think it is related to HA since all these errors occurs after database is off from HA. I don't  think there was a big transaction. However, I will...

It was in HA. I removed  it from HA to make the recovery mode SIMPLE and shrink the transaction log file. I just ran DBCC CHECKDB and below is the...

I hear you. But I'm a programmer and get paid to make whatever they want.😎

I wish I knew. That's what the business wants.I wish I knew. That's what the business wants. I am trying to figure out a way to go back to...

Thank you all.

I think I heard something like if it is more than 50% fragmented, then it has to be rebuilt. If Reorg will do its job, I will do that.

Thank you, everyone.

Never mind. For some reason, the second run after the change made it smaller.

TLog Backup: 5 AM (147 MB)

TLog Backup: 6 AM (166 MB)

TLog Backup: 7 AM (186 MB)

TLog Backup:...

I tried it without the NO_TRUNCATE. It still keeps growing.

I know. Doesn't it look like a differential. Below is the script for that TLog backup.

BACKUP LOG DBName TO DISK = @Path WITH NO_TRUNCATE, INIT

The solution was to restart the sql server agent.

Thank you.

I believe the third party back up is a windows level daily back up. it looks like the diff one doesn't cooperate with the third party one. We never had...

Wow. I didn't know I have a trace running in the server. Unfortunately, The trace file can go back up to Jul 19th. I have to find a event that...

All those messages in the log file was about me trying to fix the broken linked server. I was changing the properties on that day. Thank you guys.