September 7, 2005 at 4:49 pm
I ran a delete statement, and deleted all rows.
Can I restore all these deleted records?
We updated the table with a backup from 3.am this morning, which is okay for now.
Thanks!
September 7, 2005 at 5:00 pm
I assume you restore database at 3.00 AM and then ran some delete statement sometime in the day. Now you want to recover those records.
If you are not using any third party tools you can restore your database upto the point when you ran the delete statement (assuming your database is in full recover mode) all the changes after the delete statement you will lose.
There are couple of ways to get your data but it may not work in every scenario
Amit Lohia
July 3, 2015 at 1:20 am
This thread is almost 10 years old, but i put my comment for those who will have such a troubre and find this thread. There is a way to get back records without using any tools. There is an article which is detailed, with examples. In order to get back records, there is a need to have access to backup logs. Details here: http://sqlbak.com/blog/recover-deleted-data-in-sql-server/[/url] Hope this will be helpful.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply