Re: Errors on DBCC SHRINKFILE(2)


"Scarab" <yw@xxxxxxxxxx> wrote in message
news:dsougk$gb0@xxxxxxxxxxxxxxxxxxxxxxxxx
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



Thanks for your reply, It is really a great help to me.
I think it is strange because after I restart SQL Server, this error still
exists, so I run
DBCC CHECKDB, there is no error messages, but after a while, the file can be
shrinked normally.
My question is: how can I view the virtual log files which make up a
physical log file? Once I find them, I
can kill the session and release the file.
Thank.


.

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)
  • 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)
  • Errors on DBCC SHRINKFILE(2)
    ... When I use dbcc shrinkfile to shrink LOG file, ... Cannot shrink log file 2 because all logical log files are in ...
    (comp.databases.ms-sqlserver)
  • sh
    ... DBCC SHRINKFILE ... Cannot shrink log file 2 because all logical log files are in use. ...
    (microsoft.public.sqlserver.server)