SQL Server delete Recovery

E-mail：chf.dba@gmail.com

Title: SQL Server delete 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.]

The delete operation of the SQL server is actually similar to Oracle in nature. We can recover it in two ways: 1. directly parse the SQL log, 2. directly read the mdf / ndf file to find out the records that are marked for deletion. In the case of a log, the log analysis can more accurately locate the records (because the records that may be found according to the delete mark are not the delete operation), here is a simple recovery process. A SQL server table, the number of records 83 Article
20191119113816

20191119114937

Delete it
20191119114955

Perform recovery analysis, directly generate insert statements, and de-insert the library.
20191119115219

20191119120132

At the same time, we can also generate the corresponding redo / undo related SQL statements as needed.
20191119115920

20191119120031

At this point, we have analyzed that we can recover the lost data of the SQL server delete misoperation.
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

SQL Server drop table Recovery

E-mail：chf.dba@gmail.com

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.]

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

Backup table data for deleting before and after comparison
20191119140425

Delete table data
20191119140447

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

Compare data before and after recovery
20191119141717

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

oracle dmp encryption recovery

E-mail：chf.dba@gmail.com

Title: oracle dmp encryption 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.]

Received friend recovery request, oracle dmp file is encrypted
20191124230422

By analyzing the file, it is found that the encryption is mainly blanking and partially encrypting the head and tail blocks according to 8 bytes in each 16 bytes.
20191124230702
20191124231600

By performing recovery, skipping the damaged part, the remaining data is directly imported into the database, and the test data can be stored in the database normally through show = y, achieving perfect recovery of the dmp file table data
20191124231917
20191124232238
When your Oracle dmp(exp and expdp) is damaged for some reason and cannot be resolved by yourself, please contact us to provide professional database recovery technical support
E-Mail:chf.dba@gmail.com

.READINSTRUCTIONS encryption recovery

E-mail：chf.dba@gmail.com

Title: .READINSTRUCTIONS encryption 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.]

Some friends win file system is encrypted, with the extension .READINSTRUCTIONS, and the oracle database is running on it
20191127213813

20191127213603

Through analysis, the virus encryption is relatively severe and cannot be recovered 100%, but through a series of processing, most of the data can still be recovered smoothly.
20191127214341

If there is a file system encrypted database (Oracle, SQL Server), we can provide recovery services and promise to confirm the value of the data after the recovery and then charge. If necessary, please contact us:
E-Mail:chf.dba@gmail.com