If the transaction log and database are in the same device you can't do a transaction log dump. In this case you need do a Truncate Log on Checkpoint. You also can't dump the log if the Select ...

You really didn't read the post did you?<BR><BR>It's not that I'm not doing backups, I'm just not sure how often teh transaction logs should be backed up, and relative to when the full/diff is run ...