Hello Jon, thanks for the reply.

>Do you need to have the database in a recovery model that you can bring back online without losing any changes?

No, I don't.

>My guess from your description is that because you are doing a backup everyday that you could, if absolutelly necessary, lose a days work and go back to the previous days backup.

Correct.

>If so switch the database to Simple Recovery model, right click the database in Enterprise manager, hit properties and then options, change the recovery model to Simple...

As I am using MSDE, I do not have the EM, but I have a third-party tool which is pretty close to it. I'll investigate if I can change modes without having to resort to Alter table...

>you may also want to shrink the physical size of the file

I have just done it, and the log file has shrunk to just over 1Mb! Now if I can only get it to stay that way.

Regards,
Alan