SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Installation Question-
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

morrisos
Starting Member

9 Posts

Posted - 05/22/2013 :  14:46:45  Show Profile  Reply with Quote
Where is the best location (c:, or other drive) to install SQL server?

Currently I install on C:\ except for Data files and Log files. Would it be better to install all initially on C: and only put new (non-system) databases on a different volume? All SQL install files would be on C:\ which seems cleaner.

This would make it easier to disjoin a SAN volume or virtual disk and re-attach in needed to a different server.

The way I currently install now puts SQL prorgam files/folders on the D:\ along with the system DB's.

Thank You for any advice.

ahmeds08
Aged Yak Warrior

India
675 Posts

Posted - 05/23/2013 :  05:05:15  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Keeping Tempdb on a separate drive is recommended as a performance benefit.

mohammad.javeed.ahmed@gmail.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000