Solved

sql server 2008 instance path question

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
A procedure for exporting installed hotfix details of remote computers using powershell
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…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

932 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

18 Experts available now in Live!

Get 1:1 Help Now