Results 1 to 9 of 9
  1. #1
    Join Date
    May 2003
    Location
    Bogota
    Posts
    8

    Unanswered: Can I rollback a delete?

    Hi!

    I made a wrong delete in my database.

    Can I recover the data of that table??

    The query was:

    delete from table

    I should write something like this

    delete from table where column = 87

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sure..

    BEGIN TRAN

    DELETE FROM myTable99

    ROLLBACK TRAN

    ...you didn't create a transaction?

    Time to restore the DB from a backup to a new db and copy the data from there....

    No back up?

    How about printed listings and start typing?
    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
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    No printed listings ...
    Better think of some excuse fast.

    Any way have heard of a third party tool that might help .. am not sure .. something called log explorer from lumigent. Havent tried it out yet.

  4. #4
    Join Date
    May 2003
    Location
    Bogota
    Posts
    8
    Thank you!...Im now searching the backup information...Now the question is if I can restore only that table?

    How?

    Thanks

    JP
    Originally posted by Enigma
    No printed listings ...
    Better think of some excuse fast.

    Any way have heard of a third party tool that might help .. am not sure .. something called log explorer from lumigent. Havent tried it out yet.

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    No,

    You can only restore the whole database...

    DON"T overlay the existsing one, create a new DB (use attach), and then copy back the lost data...
    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.

  6. #6
    Join Date
    Nov 2003
    Posts
    3
    Yep, I have just started to try out Lumigent Log Explorer and it sure can recover deletes and other changes from the log.

    Haven't done anything more than some small trials on it yet, but it don't seem to hard to use.

    http://www.lumigent.com/products/le_sql/le_sql.htm

  7. #7
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Restore on to a new db, bcp out the table you want and bcp in into the old db

    You might wanna check for dependencies of the table ..

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's the cost? Is there a free demo?

    Heard about it..never had a need...
    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.

  9. #9
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Havent had the need to use the log explorer till now ... my backups work just fine ... and i just bcp out the entire database tables once a day to take care of such cases. Takes care of such cases where data is accidently deleted or updated very fast.

Posting Permissions

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