Saturday, January 3, 2015

What is the Drive Letter Standard during SQL Server Installation

So many people asked this same question- "What is the Drive Letter Standard during SQL Server Installation ?" Here is my recommendation-
Drive Letter Standard for Standalone Single Instance:
C: OS Program Files
E: CD-ROM (Wintel Team Required)
F: Software binaries
G: System data and logs
L: Transaction Log Files

H: User Data
T: Temp Database
Z: Backups

Drive Letter Standard for Standalone 2 Instances:
C: OS Program Files
E: CD-ROM (Wintel Team Required)
F: Software binaries
G: System data and logs
L: Transaction Log Files

M: Transaction Log Files
H: User Data
K: User Data
T: Temp Database

O: Temp Database
Z: Backups

Drive Letter Standard for SQL Cluster:
Node1(Local Drives):
C: OS Program Files
E: CD-ROM(Wintel Team Required)
F: Software binaries

Node2(Local Drives):
C: OS Program Files
E: CD-ROM(Wintel Team Required)
F: Software binaries

Shared LUNS(Need in Node1 to install SQL Server):
G: System Data and Logs
L:Transaction Log Files
H: User Data
M: MSDTC
Q:Quorum
T: Temp Database
Z:Backups

No comments:

Post a Comment