Solved

sql server 2008 instance path question

Posted on 2009-07-09
1
220 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 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

In this article I will describe the Detach & Attach 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.
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now