Case:
The server is an IBM server, with a total of four hard disks, 146G each, which is the SCSI interface. Recently, after restarting, the RAID card prompts that there are 2 hard disks errors.On another server, it was still unsuccessful.Internal management of special databases is very important, and no other operation is done.
Solution:
The engineer tested the hard disk to each hard disk on the dedicated work machine. It was found that there were a small amount of bad disk on the 2 and 3 hard disks. All hard disks were mirrors. The mirror took 3 hours.It’s relatively smooth.Analyze the main parameters of the original RAID5, take 20 minutes, directly loaded, successfully restore all database files, and the directory is complete.100%recovery.The maximum database file, more than 50 g, can be directly attached in SQL Server, DBCC has no error.