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

"Scarab" <yw@lucent.com> wrote in message
news:dsougk$gb0@netnews.net.lucent.com...
> 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.

[Back to original message]