Post reply

what happens when power is gone

  • June 14, 2004 at 7:51 pm

    #108137

    Hi friends

    I've some piece of code in stored proc that takes couple of minutes to complete.ofcourse all code between transaction.i mean something like

    begin transa

    --big code

    commit trans

     
    i'm wondering what happens if power is gone during the execution on the server??
     
     

  • June 15, 2004 at 3:16 am

    #510400

    all uncommitted transactions will be rolled back to keep the database in a consistent state

    cheers

    dbgeezer

  • June 15, 2004 at 2:52 pm

    #510555

    Thank u very much dbgeezer
    could u suggest a good article/resource on these transaction plz
     
     

  • June 16, 2004 at 1:49 am

    #510594

    this seemed ok at a glance ...

    http://databases.about.com/library/weekly/aa031101c.htm

    google is littered with examples on transactions and power failures

     

    cheers

    dbgeezer

  • June 16, 2004 at 2:51 pm

    #510739

    Thank u very much dbgeezer.I appreciate that

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

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