Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

While shrinkning log file of one database on SQL 2005 instance I get below message: "Cannot shrink log file 2(name) because all logical log files are in use". I am able to shrink log files of other databases successfully.

I have checked that log backup is happening successfully. I have also checked that there are no open transactions on this database. Please advise.

P.S : I know disadvantages of shrinking. I am looking for explanation to my problem and not alternate options.

share|improve this question
    
can you tell us the results of DBCC LOGINFO (YourDBName)? –  Sankar Reddy May 25 '11 at 0:34
    
Thanks for responding Sankar.It shows status 0 for all rows except coouple of rows at starting and at the end. I got the answr from below links as well : emmet-gray.com/Articles/SQL_LogMaintenance.htm and msdn.microsoft.com/en-us/library/ms345414(SQL.90).aspx These sites said that log file faced 'wrap around' due to which free portion is in middle of log file not allowing to shrink the log file. Taking log backup again is the solution. In my scenario I have no rights to take log backup as and when needed. Can you suggest any other solution here? Thanks in advance. –  Dnyaneshwar Daspute May 26 '11 at 8:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.