SIMS and SQL 2008 DB and Log files on different drives
I have installed a brand new Server 2008 R2 machine and installed SQL 2008 on it ready for migrating our SIMS install to SQL 2008 this summer.
Following Microsoft's Best Practice Guide Separate database and transaction log files on different drives for optimal performance and disaster recovery I have three separate RAID volumes on this server. RAID 1 for system / C drive, RAID 5 for Data and RAID 5 for Logs
I have set up SQL 2008 to use the separate drives for Data and Logs as default for new databases and confirmed that these settings are correct in the Server Database properties page through SQL Server Management Studio.
However, when running the SIMSInst.exe to install SIMS SQL Server parts on this machine it always copies the SIMS database and log files into the SQL Program folder on the C Drive.
How do I get the SIMS installer to put its database and log files in the correct default locations as specified in SQL Server?