Easwaran Paramasivam
asked on
How to retrieve deleted table?
I delete table1 from database db1 using DELETE command.
It is said that delete command is logged. I would like to bring back the deleted table.
How to achieve that? Please do explain with example/sample.
It is said that delete command is logged. I would like to bring back the deleted table.
How to achieve that? Please do explain with example/sample.
ASKER
Ok. Assume I've backup.
In this case whether restore the entire database is the only option to bring back the table or some other option exists? If so, please do explain in detail.
In this case whether restore the entire database is the only option to bring back the table or some other option exists? If so, please do explain in detail.
1) Restore your database under a new name.
2) Move the table from your old database to your new database.
(You can do this easily by running a query similar to "select * into OldDatabase.dbo.OldtableNa me from NewRestoredDatabase.dbo.Re storedTabl eName")
3) delete your restored database
2) Move the table from your old database to your new database.
(You can do this easily by running a query similar to "select * into OldDatabase.dbo.OldtableNa
3) delete your restored database
ASKER
@Jared_S Thanks for your comments.
I know above process by restoring the database.
As restore and delete old database is common one. Is there any other alternate option such as reading the log file and restore only the deleted table?
Please do not suggest commercial tool.
Please do provide your comments.
I know above process by restoring the database.
As restore and delete old database is common one. Is there any other alternate option such as reading the log file and restore only the deleted table?
Please do not suggest commercial tool.
Please do provide your comments.
Was your database recovery mode set to full?
ASKER
Yes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
the only way to do it is to buy a tool that can parse the log files (redgate has one) and try to generate the reverse statements for the delete you executed