Results 1 to 6 of 6

Thread: rollback

  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: rollback

    Hello every body,
    I would like to know the procedure, that how to rollback my transaction in sql server 2000

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    use pubs
    select * into Authors2 from authors

    begin tran
    delete from Authors2
    rollback tran

    select * from Authors2
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270
    What if I need to go back to some 4 or 5 transaction back...............?????

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    restore the transaction log and do a point in time recovery ...

    frankly ... from your questions it seems like you are from an oracle background ... so

    http://vyaskn.tripod.com/oracle_sql_...quivalents.htm
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    download Lumigent Log Explorer
    that way you never have to run stopat again.
    you can roll back just the transaction you want.

    or you can set a log mark before you perform a "dangerous" transaction and you can restore just prior to that transaction.

    [Books Online] Log Marks

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    You can name your transactions.

    BEGIN TRANSACTION tran1

    BEGIN TRANSACTION tran2

    Then you can commit or rollback either tran2 or tran1. You can nest these fairly deep.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •