How can we retrieve deleted rows in SQL Server 2008?

Question

Can we retrieve back deleted rows of table(s) from a database in SQL Server 2008 ?

If yes please let me know how can we do this?

see this: [How do I get back some deleted records?](http://dba.stackexchange.com/a/998) — John Woo, Oct 20 '12 at 06:13
You can get your answer [here](http://dba.stackexchange.com/questions/995/how-do-i-get-back-some-deleted-records) — andy, Oct 20 '12 at 06:13

score 2 · Answer 1 · edited May 23 '17 at 10:26

2

The example below is for 2005, maybe it need tweaks for 2008.

An easier way may be to restore it which is going to be based on your backups

edited May 23 '17 at 10:26

Community

answered Oct 20 '12 at 06:16

Ankit Chauhan

1

Thanks ankit, john & anand for quick response. I ll mark it close. – ʞɹᴉʞ ǝʌɐp Oct 20 '12 at 06:22

1 Answers1