HA!

If it wasn't for the Murphy's of the world, we wouldn't need a tlog in the first place. But here we are, now everyone gets to become very familiar with recoverability strategies. You are welcome for the contribution.

I think some folks think that if the db is in the Simple recovery model, then the tlog is not used. Wrong. The .ldf is still locked by the OS indicating that it is still in use. And deleting the .ldf with the services stopped is, uh, bad. Why? Because SQL needs and uses the tlog, even on db's which are in Simple. It just doesn't use the tlog LONG TERM. Well, this is relative; when the next checkpoint occurs and whatnot.

I'm changing my name to Jones. Just trying to keep up with Steve.

Jim