A customer found us. Due to improper operation, the drop table statement that should be executed on the standby database was placed on the production library to execute, resulting in the entire production table being droped.

By letting the customer provide relevant data files for analysis and recovery, the recovery effect is very good because the customer does not perform other operations after deleting the table.

If a sql server database is misused (drop, truncate, delete table, etc.), write operations should be avoided as soon as possible, such as: copying data files offline, stopping all database operations, etc. to prevent overwriting due to further writes, thus Make the recovery effect not good. If there is a recovery need, you can contact us:chf.dba@mail.com

The sql server drop table is essentially the data on the disk.It can still be recovered like Oracle through the underlying technology.

Backup table data for deleting before and after comparison

Delete table data

We restore the data (you can restore the table structure and table data)

Compare data before and after recovery

Through comparison, we found that we achieve perfect recovery of drop table data.
When your SQL Server database loses data due to misoperation and cannot be resolved by yourself, please contact us to provide professional SQL Server database recovery technical support
E-Mail:chf.dba@gmail.com