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.
Asked
Active
Viewed 51 times
0
-
1what database are you using? – T I Feb 12 '14 at 14:19
-
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
-
I am using MSSQL.Please help as it is very urgent. – Hardy Feb 12 '14 at 14:44
2 Answers
0
I am assuming Microsoft SQL Server. With no backup, and outside of a transaction I am afraid you are out of luck.
Chris Kooken
- 32,730
- 15
- 85
- 123
-
-
-
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
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.
Community
- 1
- 1
ChrisProsser
- 12,598
- 6
- 35
- 44