Case:
When the client’s technicians re -configure the SQL2005 database to the unit server, due to the error operation, the MDF main data file is mistakenly deleted.
Solution:
The server uses Seagate’s hard disk with a capacity of 500GB. After getting the hard disk, analyze the data disk, find the MDF file header, and quickly learn the capacity of the capacity according to the structural information of the database.A total of 243 fragments were extracted to list the searched fragments, and the software was used for intelligent sorting. Finally, the SQL database was successful. The entire library file was about 3.4GB.Manually restore the storage fragments of the database according to the MDF structure.