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
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