sql server drop table recovery


Title: sql server drop table recovery

Author: DATABASE SOS©All rights reserved [without my consent, it may not be reproduced in any form, otherwise there is the right to further legal responsibility.]

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