Currently the situation is under control with an additional full dump being run after the time of the application initiated purge. The point about backing up the log with...

Interesting. Even though you had a completely different cause for this problem, it amounted to the same thing. Somewhere, somehow the log was being truncated. In my...

Well, the problem is that we don't have much control over how the application does the purge. That is what we are looking into now. I realize...

We have identified our problem. A purge is being run through the application on Monday mornings at 1:00 AM. The person in charge of the application is checking...

OK, now I have to think about this. The weekly maintenance plan does run at the right time to mess things up but I don't see anything suspicious in...

I've already run the full backup and transaction log dumps are working again. But your suggestion is very interesting. The errorlog does

show that the server is getting...

I just checked. There is plenty of space. I don't think it's permissions either since after the full backup, the same transaction log plan works OK. We...

It's full. The same maintenance plan for transaction logs runs the rest of the time. I have tried backing up the log manually and that doesn't work either.

I did get the drift of Mordechai's solution but thanks for explaining it so simply. Also for the function which might be a useful way of handling this ultimately....

This does give me the right answer which is a definite improvement! I will want to study it a bit so I can figure out what it's doing. ...

You might check that the "sql noexec" option is not turned on in query analyzer. Select tool/options/connection properties. Uncheck the "set noexec" box if it's checked. Having...