Results 1 to 8 of 8

Thread: update

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: update

    I have updated a column(first_name) in my table emp.Instead of updating few fields which meats some criteria i have update all the rows in the DB.Its just an update stmt and there is no explicit transaction mentioned.
    I dont have a back for the table.So how can i rollback my update statement and get my old data?Any chance?
    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Where did you do this from?

    In any event, it doesn't look good, unless youd did

    BEGIN TRAN

    UPDATE Table SET Name = 'Brett'

    Then you could say ROLLBACK TRAN

    Otherwise it's already committed...

    Look into lumigent log explorer to recover the data if there's no back up

    You sure?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

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

  3. #3
    Join Date
    Apr 2003
    Posts
    176
    whats this 'lumigent log explorer'?

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Restore a backup of your database under a different name, and then Update your current data with the old data based on the table's primary key. You do have a backup, don't you? And you do have a primary key on your table, don't you?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Apr 2003
    Posts
    176
    unfortunately....I don't have any kind of backup..

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by bruce_Reid
    whats this 'lumigent log explorer'?
    Check out Lumigent's web site for more details. The log explorer is a tool that allows you to see "who done what, when" in your database, and it gives you options for "undoing" what has already been done (which is what you need right now).

    -PatP

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...and then he needs a BACKUP STRATEGY!!!!!!!!!!!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    ...and then he needs a BACKUP STRATEGY!!!!!!!!!!!
    Not really, he needed that a while ago, it's just that now he knows it!

    -PatP

Posting Permissions

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