Deleting a table accidentally

Question

You need help.

I accidentally deleted one table from my database. There is a db backup, but it is 15 days before.

Can someone tell me if I can get the table data by any means?

thanks

Answer 1

Before you do anything, make a copy of your current tran data and logs.

I never had this problem, I know some people who swear by ApexSql recovery tools - not cheap, but it might be worth it if other methods do not work for you.

Answer 2

Speaking of DROP tools and ApexSQL tools, you can refer to 4 methods for recovering lost tables due to the DROP table working in an online article for more details and methods that you can use

Disclaimer: I work as an ApexSQL product support engineer

Answer 3

• Back up your existing database.
• Restore the database from YOUR 15 DAYS OLD , but as a NEW DATABASE (under a new name).
• Fetch create a script for the table.
• Create a table in the current database.
• Use SELECT ... INTO ... to transfer data from one database to another.

Answer 4

If you back up your database and logs now (if you have not truncated / truncated them), you can restore this backup to a point in time before you drop the table. See this technology article:

http://technet.microsoft.com/en-us/library/ms179451(v=sql.100).aspx

Just make sure that you are not overwriting the old backup, as if you could not restore it to this point in time, then you may have to use the older one as indicated in other answers.

Also, make sure you restore it to the name of the new database and rename it after you are satisfied with how the data returns to how it should be.