Home Forums SQL Server 2008 SQL Server 2008 Administration transaction log file full RE: transaction log file full

  • 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