Home Forums SQL Server 2005 Backups How do I delete excess transaction logs. RE: How do I delete excess transaction logs.

  • Is your database in full recovery mode?

    Do you have transaction log backups occuring regularly?

    Do you need to be able to resore this database to the moment of failure if something happens to it?

    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