SQL Server, shrinklog

I'm trying to shrink *ldf file and getting following message:

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

Don't have any clue how to get to these logical files and disable them.

Will appreciate any suggestions.
Thanks.

They are in use because you have a long running open transaction. Run DBCC
OPENTRAN to see.


http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF : How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF : Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations


--
Andrew J. Kelly SQL MVP




are

Can you post the results of DBCC LOGINFO ?

--
Andrew J. Kelly SQL MVP




error.

are