• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 65
  • Last Modified:

SQL Server Installation Directory Recommendation

I searched the net to find out what is the recommendation regarding SQL Server installation directory.

What I found is just what I had already known about the directory recommendations which is:

a drive for data.
a drive for logs.
a drive for backup.

so what is about the installation directory itself? Is it OK to be on the same drive as the OS for better integration, or it does just follow the same style and is recommended to be on a separate drive?
0
Shadi Saleh
Asked:
Shadi Saleh
  • 2
2 Solutions
 
65tdRetiredCommented:
I'd say either or as long as the DB' and logs (and backups) are not on the OS drive.
I would if possible put the System Databases (TempDB) on a non-OS drive.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It depends on your company policy.
I've worked with companies that installs everything in the C: drive, providing a C: drive big enough for the installations.
As I also worked with companies that provided a dedicated drive (D: for example) just for installing applications.

Just don't use the database disks (Data, Log, TempDB) for the installation binaries.
0
 
65tdRetiredCommented:
Also have a look at this web site some interesting tools for SQL servers.

https://www.brentozar.com/first-aid/
0
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

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now