Results 1 to 11 of 11
  1. #1
    Join Date
    Jan 2002
    Location
    Libya
    Posts
    50

    Unanswered: Database Recovery

    Hi,
    I made an UPDATE query without specifying any criteria so I had more than 1500 records have been changed and I cannot undo the UPDATE.
    Is there any way I can recover the data UPDATE from the Transactions Log.
    I did not back up the database lately so what is the appropriate solutions for this?

    Any thoughts…
    Khalid Yousef

  2. #2
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Yes, many actually.

    However, none of them will help in your present situation.

    I would, though, suggest that you copy and paste the results window from your update statement and pin them to the wall next to your display screen. It might help avoid any future such issues.
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Have you EVER done a backup on this database?
    If it's not practically useful, then it's practically useless.

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

  4. #4
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    First you will need a DeLorean and a "flux capacitor" and some plutonium ...

    -- This is all just a Figment of my Imagination --

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    And hope for lightening at 88mph!

    Tom, that actually made me laugh out loud (and then have to explain myself)!
    George
    Home | Blog

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    old joke...


    RESTORE DATABASE MyDatabase FROM Wormhole WITH String_Theory. I wish I had the link to the thread where the OP inquired about that syntax.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  7. #7
    Join Date
    Jan 2008
    Location
    Burke, VA
    Posts
    2
    Khalid made his post from Libya. Do you think he would know the reference made to "Back to the Future"? Good luck Khalid! Back-ups are your best friend!

  8. #8
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Quote Originally Posted by DIANEH1
    Khalid made his post from Libya. Do you think he would know the reference made to "Back to the Future"? Good luck Khalid! Back-ups are your best friend!
    maybe. hollywood is one of the last things this country exports. it's OK to have a little fun with the OPs.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  9. #9
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by DIANEH1
    Khalid made his post from Libya. Do you think he would know the reference made to "Back to the Future"? Good luck Khalid! Back-ups are your best friend!
    Libyans were featured prominently in that movie, if I recall correctly!

    -- This is all just a Figment of my Imagination --

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Never used it but Lumigent Log reader often gets mentioned when this sort of question is asked.

    You are broadly pretty stuffed, as you probably gathered from the responses. Probably your most valuable lesson from all this is backup, backup, backup.

  11. #11
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Quote Originally Posted by tomh53
    Libyans were featured prominently in that movie, if I recall correctly!
    heh,heh,heh...good catch, Tom!
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

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