Posted by Dan Guzman on 02/13/06 06:07

The message means that all of there are open transactions in all of
*logical* log files. Each physical log file is made up of multiple virtual
log files and the physical log cannot be shrunk when there all of these
virtual logs are occupied with open transactions.

You can identify the oldest open transaction with:

USE MyDatabase
DBCC OPENTRAN
GO

You should be able to shrink once the transaction completes. See 'Shrinking
the transaction log' <architec.chm::/8_ar_da2_1uzr.htm> in the Books Online
for details.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"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
>
>

[Back to original message]