Solved

sql server 2008 instance path question

Posted on 2009-07-09
1
239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

736 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