I have deleted rows in a SQL table, now I want to recover those deleted rows, or I truncated all data of a SQL table. Please tell me that how can I recover truncated or deleted data of any SQL table using any stored procedure..
Asked
Active
Viewed 140 times
0
-
2Which DBMS u r using? Oracle,SQL Server....? – Arun Palanisamy Aug 13 '15 at 05:23
-
10Gently ask your administrator for a restoration of the last backup? – Aug 13 '15 at 05:33
-
I Guess if the commit commend has been executed it cannot be retracted unless you have a database/table backup. As you db admin may be? – Immortal Aug 13 '15 at 06:17
-
Perhaps having a look at this thread may help: http://stackoverflow.com/questions/9053805/recover-updated-data-sql-server-2005 – NeverHopeless Aug 13 '15 at 07:21