Post reply

Log File is in use

  • December 22, 2008 at 10:24 pm

    #383627

    Hi.

    I have taken a database backup from production and restored it in Dev server.The database size is of 160 GB.So i planned to shrink database file.i used the following statement

    DBCC ShrinkFile('ChangeDM',1)

    While executing the statement,I am getting the error "Cannot shrink log file 4 (ChangeDM_Log1) because all logical log files are in use".

    I have used the Open tran Statement to view the open transaction in Database.

    I get the following Results

    Replicated Transaction Information:

    Oldest distributed LSN : (2120809:18651:1)

    Oldest non-distributed LSN : (2120809:18920:2)

    Replication is configured in Production only and not in my Development server.

    Please Help me to resolve the issue

  • December 23, 2008 at 1:05 am

    #916604

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://qa.sqlservercentral.com/Forums/Topic624449-5-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply