Thanks Matt & Lynn.

Sorry for not being clear enough. I did want the entire row returned, so I ended up using Matt's script.

Thank you both again for your help...

You're a champion, Chris!

Thank you very much! 😀

So I'm reading up on truncating the log file with the SHRINKFILE method.

Is this the way I should use it?

DBCC SHRINKFILE('database_log.ldf',TRUNCATEONLY)

And this will ultimately remove all transactions from the log...

Now it says "LOG_BACKUP"

That returned "No active open transactions."

The latest value in that field (created on the 27th of this month) was "ACTIVE_TRANSACTION"

This is a production DB. It's a DB that our company RMS uses. I can boot everyone off it whenever if need be.

So truncate, shrink, and backup..

OK, I did a shrink on the log file and it released about 5gb. It's still over 200gb. The data file is only 600mb. Is truncating the only way to...