Posted by Dan Guzman on 02/13/06 15:35

The undocumented DBCC LOGINFO can display virtual log stats.

Also, outstanding replicated transactions can prevent log
truncation/shrinking.

--
Hope this helps.

Dan Guzman
SQL Server MVP

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