Posted by Scarab on 02/13/06 05:30

Hi,
When I use dbcc shrinkfile to shrink LOG file, following error occurs:

DBCC SHRINKFILE(2)
----------------------------------------------------------------------------
-----------
Cannot shrink log file 2 (myDB_log) because all logical log files are in
use.
(1 row(s) affected)

I have only one transaction log file in my Database, who can tell me what't
the matter?

If my current log file is in use, how can I find who is using it and stop
using then do the shrink operation?

Thanks.

Scarab

[Back to original message]