Here, to make a warning to everyone, database hard disk, try to do raid or other disk array!
Environment: Win Server Enterprise 64-bit.
HDD: SSD (System disk) + 2T (data disk)
Problem: 2T data disk, one will be displayed in the system, a will not display, and then display. It's not going to work. (The data on the hard drive is on!) )。
WORKAROUND: 1. Rebooting the system does not work
2. Insert the 2T data disk on another machine, or the same symptoms occur. Guess the database hard disk due to a large number of IO operations, causing problems with the hard disk.
3. On the other server, import the previous days ' backup (bak file) into another database, and then insert the data for a few days.
总结:数据库一定要做RAID1或者其他磁盘阵列,出现一块硬盘有问题的时候,另一块还可以用。 我已经坏掉的硬盘照片: ![](http://i2.51cto.com/images/blog/201806/10/8f9d9d8745e78449cb9621c686339a72.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)![](http://i2.51cto.com/images/blog/201806/10/14edd9b9508b954551fa2f5fdf479f6f.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_100,g_se,x_10,y_10,shadow_90,type_ZmFuZ3poZW5naGVpdGk=)
Database hard disk is broken!!!