>You didn't say the version of SQL Server but for 7 look up DBCC SHRINKFILE.
>
>The trick is that the active virtual log has to be towards the front. You can use DBCC LOGINFO to view the virtual logs. Look for a two in the status column. That will be the active virtual log.
>
>-Mike
yep - it's 7 - thanks Mike - it'll be a day or two before I can look at it again, but I'll give it a try.
Thanks,
Ken B. Matson
GCom2 Solutions