SQL2000 database with the same name overwrite data recovery

These days, a number of customer database repair cases, spare time, write and write the repair process!

Cause: The customer restores the website program, the first time restore because the SQL Server did not stop, so the error, the customer simply shut down the SQL Server for a second operation, the operation was completed only suddenly found that the database was the same name of a database of 2M was overwritten.

Processing: After receiving the disk through the top-level SQL Server Software Scan, found that the file header has been overwritten, but the tail of the data is still intact. Because the overwritten and overwritten databases belong to the same, and the database structure is identical. As a result, the second half of the fragment of the uncovered database is recovered, and the database file can be repaired.



The result: Fortunately, the front part of the overlay is only 2m, while the SQL MDF database file header holds system data such as system tables, and the database structure of the overlay is exactly the same, so the recovery database is restored directly to the customer database 100% successfully. , and luck is still good!


It is not too tense to meet the same name of the database, it is the key to recover the game. I will write my own database software in a few days to share it!!


Contact Tel: 18768428642
Customer Service qq:1071042474

This article from "Sqlrecovery" blog, declined reprint!

SQL2000 database with the same name overwrite data recovery