Improve company productivity with a Business Account.Sign Up

x
?
Solved

sql server 2008 instance path question

Posted on 2009-07-09
1
Medium Priority
?
251 Views
Last Modified: 2012-05-07
Hello,

I'm looking for the best practice when installing SQL server 2008 - should the default instance path be different from the system drive?  I have a mirrored system drive along with a mirrored data drive.  Should I put it on the mirrored data drive?

Any other best practices I should follow?  Potential gotchas?

Thanks for your time.
0
Comment
Question by:jands
1 Comment
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 24820339
>> should the default instance path be different from the system drive?

Not necessarily. You can move the user databases as required. Installation can reside in the system path itself.

>> I have a mirrored system drive along with a mirrored data drive.  Should I put it on the mirrored data drive?

Installation can reside in System drive and user databases in data drive.

I would suggest you to follow the approaches below:

1. Instance Installation in C:\ or system disk
2. Move all User databases primary file ( MDF) to separate disk.
3. Move all user databases Log file (LDF) to another disk if available.
4. Move tempdb to another disk if available.

Kindly note that it was physical disk / drives and not the partitions in your machine.
0

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits …
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question