Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I know it's possible to change many of the default paths when installing SQL Server, and generally when I do an install I change the data and log folders to be on separate drives (typically D and E), however I've recently been given a pre-installed machine which is running an instance name other than the default and they've configured the instance root directory to be on the D drive along with the mdf files. This means that on what would normally be a relatively clean drive with just folders and database files on it I now have a full installation of the SQL Server binaries as well.

i.e. I now have the following :

C:\Program Files\Microsoft SQL Server\ --Base Install
D:\Microsoft SQL Server\MSSQL10_50.MyInstance --Instance Binaries
D:\Microsoft SQL Server\MSSQL10_50.MyInstance\MSSQL\DATA --Data Files
E:\Microsoft SQL Server\MSSQL10_50.MyInstance\MSSQL\LOGS --Log Files

Where normally I would run with something like :

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ --Base Install & Default Instance Binaries
D:\MSSQL\DATA --Data Files
E:\MSSQL\LOGS --Log Files

I can understand why having a separate instance binary folder is necessary, but I can't see why it would be useful to put all those binaries on a separate drive.

Can anyone tell me why it might be a reasonable thing to do? Or perhaps it just makes no difference at all? To me it just seems terribly untidy...

(cross-posted from stackoverflow - apologies if this is frowned upon!)

share|improve this question

closed as off topic by JNK Nov 12 '12 at 14:30

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

Please do not post the same question on multiple sites. I'm closing this one since it was opened after the one on SO. We can move that Q to this site if needed but having multiple copies causes all kinds of issues. –  JNK Nov 12 '12 at 14:30
That being said we are in the process of pulling the question to this site, which is where it probably belongs. –  JNK Nov 12 '12 at 14:31
Fair enough, although it is perhaps telling that the question on SO has managed a response already (albeit not a useful one), whereas on here there's been nothing. –  adhocgeek Nov 12 '12 at 14:33
Some questions need their time to be answered. It's night in the Americas when it's day in Europe and vice-versa so it's better to wait at least 24 hours for a more than trivial question. –  ypercube Nov 12 '12 at 14:37
@adhocgeek I understand. If we migrate from SO then the question still exists there, it's just a link to here. That way all the activity happens in one spot. –  JNK Nov 12 '12 at 14:43