Maintenance plan transaction log backup hangs
Posted on 2006-04-17
We have a maintenance plan for transaction logs and it hangs on the same database every time for the last week. I did DBCC CHECKDB and nothing came up wrong. The log file for the maintenance plan is 0 bytes even with all the other db logs backing up. Running a t-log backup manually in SQL Query Analyzer works fine. The version is SQL 2000 Enterprise edition at sp 1.
The db is rather small (only 3 GB) compared to others on the same server.
I've tried everything I can think of short of a reboot, any ideas????