Author |
Topic |
sqlguy7777
Starting Member
14 Posts |
Posted - 2010-12-21 : 17:47:40
|
Hi
I am installing a cluster.
C: local disk D: local disk F: Cluster drive G: Cluster drive M: Cluster drive Q: Cluster drive
Question 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 thanks
SG |
|
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
|
Hi
So 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:
Cheers
SG. |
 |
|
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 |
|
|