Menu
Need a help badly.
I accidentally dropped one table from my database. There is a backup of the db but it is of 15 days before.
Can someone tell me if I can get my table data by any means?
Thanks
322
The . undo drop table command reverts a drop table operation to a specific database version. The command must be executed with database context.
Once a table is dropped, it is gone. Without a backup you won't get it back. So, no there's no way to undo the drop statement.
Before you do anything, make a copy of your current data and tran logs.
I never had this problem myself, by I know some people that swear by the ApexSql recovery tools -- not cheap, but can be worth it if other methods don't work for you.
137
Speaking of DROP table and ApexSQL tools, you can reffer to the 4 techniques for recovering lost tables due to DROP Table operation online article for more details and methods that can be used
Disclaimer: I work as a Product Support Engineer at ApexSQL
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
