Post reply

Database triggers and simple recovery model

  • February 27, 2008 at 11:09 pm

    #182747

    In a simple recovery model transactions are minimally logged so in that case if trigger is executed against an underlying table how the trigger uses its pseudo tables like inserted and deleted as they are the views of transaction logs.

  • February 27, 2008 at 11:56 pm

    #783007

    In simple recovery mode, all transactions are fully logged.

    When the transactions have committed, and the dirty data buffers have been flushed to disk, the log entries are marked inactive (no longer necessary) and are cleared out of the log file.

    I believe that in SQL 2005, the inserted and deleted tables now use the row version store and not the transaction log. Not 100% sure though.

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

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