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

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]