Errors on DBCC SHRINKFILE(2)

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


.

Relevant Pages

  • RE: Delete large table in chunks to minimise log file growth
    ... Restrict log file growth ... Cannot shrink log file 2 because the logical log file located at ... system administrator. ...
    (microsoft.public.sqlserver.server)
  • Re: Delete large table in chunks to minimise log file growth
    ... You can run DBCC Loginfocommand to look at status column. ... transaction and solution is to BACKUOP the log file or running dummy INSERT ... Cannot shrink log file 2 because the logical log file located ...
    (microsoft.public.sqlserver.server)
  • sh
    ... DBCC SHRINKFILE ... Cannot shrink log file 2 because all logical log files are in use. ...
    (microsoft.public.sqlserver.server)
  • Delete large table in chunks to minimise log file growth
    ... Restrict log file growth ... Cannot shrink log file 2 because the logical log file located at ... system administrator. ...
    (microsoft.public.sqlserver.server)
  • Re: Errors on DBCC SHRINKFILE(2)
    ... When I use dbcc shrinkfile to shrink LOG file, ... DBCC SHRINKFILE ... Cannot shrink log file 2 because all logical log files are in ...
    (comp.databases.ms-sqlserver)