Hi Adam

I did mention that this is done after database is backedup... i completely agree with you... may be i should have highlighted it in bold.

... >> A .bat...

Example database name: 'Cheerios'

Cheerios_log: this is the physical file name of the log file

Basic idea

change the db recovery mode to simple

clear log

...