Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Am about to try and install SQL Server 2008 R2 for the second time. How and when during an install can I configure my data to be held on the D:/ drive as opposed to the default C:/ drive?

share|improve this question
    
should probably move this over to dba.stackexchange.com –  James Love Jul 23 '12 at 19:37
    
Indeed good sir. –  RJ Cuthbertson Jul 23 '12 at 19:46

2 Answers 2

up vote 3 down vote accepted

http://msdn.microsoft.com/en-us/library/ms143219.aspx

Step 15:

Instance root directory — By default, the instance root directory is C:\Program Files\Microsoft SQL Server\110. To specify a non-default root directory, use the field provided, or click Browse to locate an installation folder.

share|improve this answer
    
Thanks, this was driving me nuts! –  IrishChieftain Jul 23 '12 at 19:38
    
No problem. You have to configure the instance instead of accepting the default. Glad to help. –  RJ Cuthbertson Jul 23 '12 at 19:46

To get the full control to it when you come to the "Database Engine Configuration" step: enter image description here Click the tab Data Directories:

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.