Posted by Erland Sommarskog on 02/13/06 13:31

Scarab (yw@lucent.com) writes:
> 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.

I don't know the answers to your questions, but maybe you should think
twice before you shrink at all. Have you read
http://www.karaszi.com/SQLServer/info_dont_shrink.asp?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Design Tool
• Prev in forum: ANN: Database Workbench 2.8.1 released!
• Thread view: Re: Errors on DBCC SHRINKFILE(2)

[Reply to this message]