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.
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:firstname.lastname@example.org