Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlguy7777
Starting Member
14 Posts |
 Posted - 2010-12-21 : 17:47:40
|
| HiI am installing a cluster.C: local diskD: local diskF: Cluster driveG: Cluster driveM: Cluster driveQ: Cluster driveQuestion I have is what is best practice for location for Master, msdb, tempdb and model dbs please - on local drive or a clustered drive?Many thanksSG |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlguy7777
Starting Member
14 Posts |
Posted - 2010-12-21 : 17:57:01
|
| Ok thanks.I had it set up like this:Binaries - C:\<default location>Data MDBs and system MDBs - F:Data LDBs amd system LDBs - G:MSDTC resource - M:Quorum resource - Q:What do you think? Sorry - I am not that experinced in clusters. Also, could you please tell me where you think ( which drives ) to put things? Some of th ecluster terminolgy I dont undertnd yet.Thanks in advance,SG |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlguy7777
Starting Member
14 Posts |
Posted - 2010-12-21 : 18:03:34
|
| HiSo are you saying - all system db on their own cluster drive ( except tempdb whic is put on a separate cluster drive), and MDBs on one drive and LDBs on another cluster drive ?e.g. this is what I think you mean? Binaries - C: ( local drive )Master, model , msdb - D: ( cluster drive )tempdb - E: ( cluster drive )Data MDBs - F:Data LDBs - G:CheersSG. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlguy7777
Starting Member
14 Posts |
Posted - 2010-12-21 : 18:13:14
|
| OK, will do.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Install locations - system dbs