Home Forums SQL Server 2005 SQL Server 2005 General Discussion Can we take a transaction log backup in simple recovery model? RE: Can we take a transaction log backup in simple recovery model?

  • April 4, 2009 at 2:44 am

    #971995

    randhirdadwal (4/3/2009)

    I have tried doing that and I was able to take a transactional log backup only using the option with with truncate only.

    Backup log with truncate only means truncate the log and don't write a backup file out.

    No matter what recovery model the DB is in, that command will never write a backup file out and, on full/bulk logged, it will break the recovery chain preventing further log backups until a full backup is taken.

    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