Post reply

Power failure using simple mode transaction Log

  • July 9, 2005 at 11:59 am

    #109992

    Any comments about what happens when we get a power failure using simple mode

    transaction Log?

    I had 3 Power failure and there has not been any problems with the data.

    The auto recuperation informs that 5343 rows where commited and 0 rolled back.

     

  • July 12, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • July 12, 2005 at 11:24 am

    #573577

    The basic jist.

    when records are changed or added to the databse they are first written to the transactoin log then every so often sql server posts transactions from transaction log to the actual db file. and issues a checkpoint to the log to reuse the space. In the event of a power failure sql server may have some items left in the transaction log that have not been posted to the db. so it brings up the database, checks it for consistency errors, then applies any uncommitted transactions from the log to the db. Thats why you see 5000 rows commited.

     

  • July 14, 2005 at 3:28 pm

    #574606

    Thanks Ray

    Your comments have helped.

    Greets.

     

Viewing 4 posts - 1 through 3 (of 3 total)

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