how to recover deleted records in sql table?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chary99
    New Member
    • Oct 2011
    • 1

    how to recover deleted records in sql table?

    Hi,

    How to undo deleted records from a table in sql?

    I've used where clause to deleted some thing like where null values are inserted but entire table rows are deleted.

    Please if anyone can help in this regarding is highly appreciated.

    Thanks,
    Chary K
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Restore from a backup. If you don't have a backup, first of all, why don't you have a backup, what are you thinking? Second, depending on your recovery model, you may be able to restore records from the logs, you will need to download or buy a log explorer. If you are running under simple recovery model or the logs have already been purged, there's not much else you can do.

    Comment

    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878

      #3
      Or if you have a transaction set. Looks like you don't. Restoring backup is your only resort.


      Good Luck!!!


      ~~ CK

      Comment

      Working...