Home Forums SQL Server 2005 Backups Why do databases in Simple Recovery Mode need transaction log? RE: Why do databases in Simple Recovery Mode need transaction log?

  • It's needed for a couple of small things like transaction rollbacks and crash recovery on restart (ensuring a consistent database)

    If there was no transaction log, then any failure in any data modification, any explicit rollback, any uncontrolled shutdown would require that the database be restored from backup afterwards as there would be no other way to get back to a transactionally consistent state. Except that full backups need the transaction log to be transactionally consistent too.

    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