Post reply

transaction log file full

  • October 28, 2012 at 11:38 pm

    #270211

    How do I solve this error please?

    Thanks

  • October 28, 2012 at 11:56 pm

    #1553605

    Can you be more descriptive on this.

    DB Recovery mode:

    Is Differential Backups been taken every while.

    OR.. Do this

    DBCC Shrinkfile(Adventureworks2012_Log, 512);

  • October 29, 2012 at 12:49 am

    #1553614

    It can be because ur log file is set to restricted growth or drive on which log file is kept is full.

  • October 29, 2012 at 1:02 am

    #1553620

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

  • October 29, 2012 at 1:03 am

    #1553621

    Thanks mahesh:

    Lets say if the drive is full, what options do we have apart from growing the mount point capacity.

    Or is there a way to match the LSN here? the tran log backup is failing because the log space full.

    how can I change the log_reuse_wait to 'NOTHING' from 'Replication'

  • October 29, 2012 at 1:09 am

    #1553623

    Mac1986 (10/29/2012)

    Thanks mahesh:

    Lets say if the drive is full, what options do we have apart from growing the mount point capacity.

    Or is there a way to match the LSN here? the tran log backup is failing because the log space full.

    how can I change the log_reuse_wait to 'NOTHING' from 'Replication'

    Please don't post in multiple threads for the same problem. I answered you in the thread you started, please keep the discussion there for simplicity and clarity.

    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

  • October 29, 2012 at 2:51 am

    #1553645

    Hello Master Gail: Thanks a million for such beautiful article on log behavior.

    Quick Question: I have seen a situation where the there is no replication setup on the DB . CDC is wnabled. and the log_reuse_wait_desc shows as 'Replication'..

    As per the article, undistributed transaction is causing the Log Growth. how can i check if which undistributed LSN ((43831:51:1) in my case) provided in DBCC OPENTRAN output is pointing to DDL operations of type ALTER TABLE.

    how can i relate and compare the LSN in OPENTRAN with DDL Operation

    Please have your comments on this..

  • October 29, 2012 at 3:09 am

    #1553649

    Mac1986 (10/29/2012)

    Hello Master Gail: Thanks a million for such beautiful article on log behavior.

    Quick Question: I have seen a situation where the there is no replication setup on the DB . CDC is wnabled. and the log_reuse_wait_desc shows as 'Replication'..

    As per the article, undistributed transaction is causing the Log Growth. how can i check if which undistributed LSN ((43831:51:1) in my case) provided in DBCC OPENTRAN output is pointing to DDL operations of type ALTER TABLE.

    how can i relate and compare the LSN in OPENTRAN with DDL Operation

    Please have your comments on this..

    Please don't post in multiple threads for the same problem. I answered you in the thread you started, please keep the discussion there for simplicity and clarity.

    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 8 posts - 1 through 7 (of 7 total)

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