I am running into issues when trying to shrink a transaction log file with
query analyzer on SQL 2000. I am getting this error message

Cannot shrink log file 2 because all logical log files are in use.

Thanks

Check out the concept of virtual log files and DBCC LOGINFO:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/


"Rustom" <RustomNB (AT) hotmail (DOT) com> wrote

Sounds like you have a long running open transaction. You need to commit or
roll that back before you can shrink the log or even reuse those VLF's.
What does DBCC OPENTRAN() say for that DB?

--
Andrew J. Kelly SQL MVP


"Rustom" <RustomNB (AT) hotmail (DOT) com> wrote