Get 2 days to solve, sweat ...
Prerequisites: Windows2000 SQL6.5 Database Backup. Phenomenon: The bad sector appears in the C drive, and the system cannot start.
Workaround: First copy the database from the D disk (fortunately the database is not in the C disk), (but not the entire disk is broken, otherwise there is no remote backup, finished) Discover the TEMP database corruption (CRC error, unable to copy) , Then then low-level formatting of the disk, OK will find problems, because there is no SQL6.5 installer, can only recover from the system's image, after completion, prompt SQL unable to start, can not find .. .... Temp.dat. What should I do? No installation file, lost the system's database, urgent fire, you can't sleep, after n type attempt, found that other database files are named this file, the database It can be started (I am renamed Master.dat as Temp.dat), but, I am unfortunate, 2 databases are questioned, what do I do wrong? No way, re-establish database devices, then from backup Restore, unfortunately, the log database device has problems, no matter whether it, delete it, anyway, then re-establish the device, add the database, the problem has occurred again, the backup device only supports the production time of my system mirror Where is the problem? No way, try to choose a backup device, actually display the day before, OK is it.
