Can the data & log files be on the same disk drive?
I have always been told to keep them separate, but my boss wants to setup our new cluster server with RAID10. Issue: we don't have enough drives to keep the logs separate on a RAID1, so he wants to combine them. Is there any downside with doing this?
Also: since we are clustering the server, won't we still have to backup the databases with maintenance plans? He keeps telling me its a mute point.
Thank you for any advice.