I know that best pratices is to put the LOG (.LDF) files on a RAID1 configuration, but what about the DATA (.MDF) files. Is it okay to put it on the second channel in RAID1 as well? Or is it better to have RAID5 on the second channel for the .mdf file? What do you have to say? Please provide you thoughts and aso any links to published documentation.
Thank you very much and have a great day.