I recently installed SQL 2005 Workgroup Edition on my Windows 2003 Small Business Server. I have 2 drives mirroring each other as drive C: with my OS also installed on it. I also have a RAID 5 setup with 3 disks as my D: drive. I installed SQL Server on my C drive and I'm looking for some advice. Is there anyway I can move my data folder to the D drive for more redundancy? I am also going to have alot of data in the database eventually so it may grow to large to fit on the C drive. When I installed it, it upgraded some other SQL desktop instances so I'm kinda of afraid to uninstall.
Please recommend what I should do in this situation. I should also store my log files on seperate disks than the data correct?