>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
Mike,
I am having the same problem. DBCC LOGINFO shows 275 records, only one of which is of status 2. I still cannot truncate using DBCC SHRINKDATABASE or BACKUP LOG WITH TRUNCATEONLY. How can it be done?
Aristotle