We had a bunch of disks fail in the RAID 10 that holds the data, logs, and backups drives on a SQL Server 2012 on Win 2012R2 OS. The OS and DB Server instance are in a separate RAID array.
Working with Dell, they recommend replacing the failed drives and then rebuilding the RAID array because the array has 300+ consecutive bad blocks. At this time, there is no obvious infidelity of data.
What would be the best steps to save my data, rebuild the array and restore the data? Would it be better to restore from backups or attach physical files? What happens to your SQL Server instances if there is no Master DB? It seems to me there are 2 possible scenarios
Take the DBs offline or single user, backup all the DBs off the server, rebuild the RAID, reinstall SQL Server if necessary and restore all the DBs from backups.
Turn off SQL Server services. Change SQL Server services to manual start. Copy all the log (
.ldf) and data (
.mdf, .ndf) files off the server, rebuild the array, copy the files back, and restart SQL services. Maybe I should take the backups first in this scenario as well.
What do you think?