Hi,

You can either do

dbcc shrinkfile (dbid, n) --where dbid is the fileid in sysfiles and n is the target MB size

Or

backup log yourdbname with truncate_only

Ritch

Edited by - Ritch on 06/18/2003 03:09:00 AM

Edited by - Ritch on 06/18/2003 03:30:42 AM