Ratheesh.K.Nair (10/24/2015)
DB went to suspect because of disk went offline. Another DBA went and rebooted the server and many other DB went suspect but all came to normal after another reboot. Is it advisable to do reboot when DB goes suspect because of disk issue?TIA
Doesn't make sense, during a planned shutdown sql server will be stopped and buffers flushed to disk before the disks are unmounted! :ermm:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉