Thank you for the Open Transactions query. I have checked and there are no active open transactions. I will continue to check periodically to see if long-running open transactions appear...

Thank you for the prompt response. Unfortunately, we have already covered these bases and found nothing to explain the rollback.

ALZDBA (12/9/2010)

---

- someone may have restored your db to that point...

That works beautifully. Thank you for the help.

Got it. Don't use a BACKUP LOG WITH TRUNCATE_ONLY statement in a script for a full backup. That prevents you from running periodic LOG backups. If you don't choose to...

Let's close this thread. I believe I am on the right track. There are a few bugs in my script, above, that I caught. But there is one that I...

Thank you both! DBCC SQLPERF(LOGSPACE) worked to show me how much was in the LOG file. And the WITH TRUNCATE_ONLY line is indeed needed to keep that amount from growing.

I...