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 |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2004-11-22 : 14:51:29
|
| Yes, I know I should use QA to do this, but this is bugging me.I have a Clustered SQL server that's been running for a few years. We have G:\ for our logs and H:\ for our data. In EM, I get both of those paths as an option when creating a new database.We've recently setup a new Clustered SQL server on a different set of hardware. It too has G:\ and H:\, but G:\ is not an option in the "Locate Data File" window.Any ideas on this one?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-22 : 14:54:02
|
| I don't think it would work in QA either. Since EM can't see G, I'm pretty sure neither can QA. I would guess that something is wrong in the clustered setup.Tara |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-22 : 14:57:35
|
| The machine in question where I'm running EM can see H: and G:. Both physical resources are in the same group in Cluster Admin.Both drives are formatted etc.What in the clustered setup would I look to see if I can resolve this?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-22 : 15:09:08
|
I consider you to be the clustering expert.  EM will show any drive that it thinks is local, so I'm guessing something is misconfigured to not show it as local. Is G on the same node that this instance is on?Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-22 : 15:17:51
|
| Yes, It's on the same node. I'm just trying to figure out what we did on the old one to make the new one work the same way.I'm not sure if I do a CREATE DATABASE in QA, will it work etc.I guess I should just try it in QA and see what happens.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-22 : 16:19:42
|
| Solved!Somehow we forgot to add the G:\ as a dependancy of the SQL Server resource. We did that, and all is well!Micahel<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
New Database Location issue