How to recover table from the laste updated query in SQL?

Question

I have accidentally executed an update query in SQL, I need to recover the changes. No backup has taken for the DB. After the update query I have not executed any subsequent queries.

If you're not working in a transaction and you don't have backups, I'm afraid you can't do a recovery. — Kurt Du Bois, Feb 12 '14 at 14:20
Oracle has flashback which can be used if enabled on your database. If you're using another RDBMS then I don't know of a way. — ChrisProsser, Feb 12 '14 at 14:21

score 0 · Answer 1 · answered Feb 12 '14 at 14:21

0

I am assuming Microsoft SQL Server. With no backup, and outside of a transaction I am afraid you are out of luck.

answered Feb 12 '14 at 14:21

Chris Kooken

31,984
14
81
117

Depends on the RDBMS and options set on the database set up. – ChrisProsser Feb 12 '14 at 14:22
Since he said SQL, i am assuming sql server. – Chris Kooken Feb 12 '14 at 14:23
It may be SQL Server, but SQL is also the name of the language used for Oracle, MySQL, PostgreSQL etc. – ChrisProsser Feb 12 '14 at 14:24
Yes. I know that. I have updated my answer to be MS SQL specific. How about removing the down vote? – Chris Kooken Feb 12 '14 at 14:25

score 0 · Answer 2 · edited May 23 '17 at 10:33

0

It may be worth checking out the transactional logs referred to in this article. I have not tried this personally, but this is the angle that I would look into if I was in the same position.

It may also be worth looking at this stack overflow answer.

edited May 23 '17 at 10:33

Community

1
1

answered Feb 12 '14 at 15:18

ChrisProsser

11,828
6
35
43

How to recover table from the laste updated query in SQL?

2 Answers2