#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Nobbies beach, Gold Coast. It's beautiful.
    Posts
    2,574
    Rep Power
    171

    What are the options to get deleted data back from a database?


    hello;
    If some records have been deleted like below, is thre any ways of getting them back at all? If so would be the same in every database system?
    Code:
    DELETE FROM members WHERE expire = '2013-04-03';
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,026
    Rep Power
    4210
    yes, there is a way, and it's exactly the same in all database systems -- make sure you have a backup of the data
    r937.com | rudy.ca
    please visit Simply SQL and buy my book
  4. #3
  5. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Nobbies beach, Gold Coast. It's beautiful.
    Posts
    2,574
    Rep Power
    171
    Originally Posted by r937
    yes, there is a way, and it's exactly the same in all database systems -- make sure you have a backup of the data
    I'll get back on this one. I keep getting ahead of myself.

IMN logo majestic logo threadwatch logo seochat tools logo