Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2010
    Posts
    40

    Unanswered: How to recover lost data

    One of my developer deleted all the data from a table using 'delete from tablename' statement,how can I recover this data?

    it happened in test db though, but want to get familiarize so that if such situation comes in production I can face it.

    Alternative is to bring the data from prod and put it here. but I want to recover the lost data.

    hope I am clear about what I need.

    Thanks
    Rajesh.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Have you heard of back up and restore ability?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Aug 2010
    Posts
    40
    Quote Originally Posted by Cougar8000 View Post
    Have you heard of back up and restore ability?
    I have a last night's backup but that is full db back up. I dont want to restore the entire Db but just recover the table's data.

    Can I just restore this table from the full backup?

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Rajesh1203 View Post
    Can I just restore this table from the full backup?
    Sure. Restore the backup into a new database, export the missing table data, then load it into the old database.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Or you can restore selected tablespaces into a new db if you're using v9.x (check "Database rebuild" in the manual)

  6. #6
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    And when you are done review access on your tables.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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