IDE: Microsoft SQL Server Management Studio

Mistakenly I have cleaned a table data using

delete from table tblBookData

and now it has cleaned that table, please tell me is there any way to get back that data?

If yes than please tell me the process, as I have studied there is a way to get back data if we have not closed the session.

  • 8
    Restore your backup – a_horse_with_no_name Apr 21 '14 at 9:13
  • I don't have backup, Is there any way using rollback? – user3410150 Apr 21 '14 at 9:15
  • np. also check docs what rollback is. – Marcin Orlowski Apr 21 '14 at 9:17
  • 2
    No, there is not. – Patrick Hofman Apr 21 '14 at 9:17
  • 1
    Pro Tip: Never ever use a DELETE WITHOUT a WHERE CLAUSE - unless you know that everything is going to get deleted :-) ... – Kin Shah Apr 21 '14 at 15:49

Restore the DB into another DB , while restoring select "To a point in Time" and select "A specific date and time" and enter the date time before you deleted the record

| improve this answer | |
  • 2
    How does taking a backup of an empty table help restoring it contents? – mustaccio Apr 21 '14 at 13:17
  • 1
    I think there's a language issue here -- what's meant is "take" as in "use", not "take" as in "create." – Jon Seigel Apr 21 '14 at 14:26
  • no need to take backup,you can restore the DB into another DB...but the time you specify should should be the time at which you believe there is data in the table... – Anto Raja Prakash Apr 22 '14 at 4:27