I'm going to answer my own question. This active transaction was a process started by my online backup software via Evault. The process was hung up due to...

When running dbcc opentran on my database there is a active transaction:

Oldest active transaction:

SPID (server process ID) : 144

UID (user ID) :...

Thanks! I'll look into the DBCC OPENTRAN function.

I have not told you that I'm also using an offsite backup service (Evault) to backup the database over the internet daily. Evault is successfully backing up the DB...

This DB is in Full Recovery mode. I'm backing up the Transaction Logs every 4 hours. If there was a catastrophic failure, 1 hour of lost data would...

Thanks homebrew. That second link is what I was looking for.

I found this article: http://www.myitforum.com/articles/18/view.asp?id=4077

Can anyone confirm these instructions?