How to get back sql table data?

Question

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.

Anto Raja Prakash · Answer 1 · 2014-04-22T04:26:45.433

0

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

edited Apr 22 '14 at 04:26

answered Apr 21 '14 at 10:14

Anto Raja Prakash

109
1

How to get back sql table data?

1 Answers1