SQL Server Partition - File Placement According to Microsoft best practices you can optimize SQL and take a lot of benefits by using this technique, my only question is how to correctly install the SQL Server to match the drives/paths according to their article:

https://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx

I got my system partitioned matching the article above:


C: SYSTEM  
D: TEMP DATA  
E: TEMP LOGS  
F: SERVICES DATA  
G: SERVICES LOGS 
H: CONTENT DATA  
I: CONTENT LOGS  
J: BACKUP DATA


During the setup wizard I'm prompted for the directories (see below) but I can't figure the correct matching for all my drives/paths, I'm not sure at this point if my assumptions are remotely correct, even more, where do "Services Data" and "Services Log" will go? The options below aren't enough to match all my drives, I'm pretty sure I'm missing something and I'm lost here :)



My questions are:


How to match the drivers/directories to meet the aligned partition structure?
Is it possible to configure the Config.ini to automate this scenario?
I think I nailed this thing! Took me a lot of work but I think I could put this together and here it is what I did on my system:


C: SYSTEM = where SQL is installed
D: TEMP DATA = Temp DB directory
E: TEMP LOGS = Temp DB for logs
F: SERVICES DATA = Database Engine root INSTALLSQLDATADIR=F:\ServicesData
G: SERVICES LOGS = MSSQLServer Service startup to -G:\ServiceLogs\Logs\ERRORLOG
H: CONTENT DATA = User database  (*.mdf)
I: CONTENT LOGS = User database logs (*.ldf)
J: BACKUP DATA = The SQL backups