CODEWITHSUNDEEP
sql-server
Kosal
Kosal

Reputation: 13

How to roll back deleted data in SQL Server table for last deleted

I would like to ask you a question I deleted data from table HR_EMPMAST and I want to roll back it the last delete. Could you help me please?

DELETE FROM HR_EMPMAST

Upvotes: 0

Views: 8965

Answers (1)

hewi
hewi

Reputation: 1396

The simple and sad answer is: you can not.

They only way to 'undo' such a DELETE FROM statement is if you actually have saved a back-up from your database from before the delete. You can then either import that back-up in full or you can use the IMPORT FROM statement.

Unfortunately, if you have not saved a copy, that data is lost. That is also why the sql admin asks you if you are sure you want to delete. in-revertible!

Upvotes: 1

Related Questions