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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-08-14 : 09:27:38
|
| We have two cluster which are working great.Now we decided to allocated another Drive on our SAN to the data files.I see the new Drive in the cluster administration called RBut when i go to it and add database inside of SQLIt gives error:Only formatted files on which the cluster resource can be used.Any suggestions. |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-08-14 : 11:58:51
|
| Have you added the New SAN Drive to the SQL Server Resource group in Cluster Administrator?-- RegardsTony The DBA |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-08-14 : 14:25:17
|
| Thanks....no the network guy forgot that part.So we have to stop SQL then add the SQL Server Resource group in Cluster Administrator?and restart SQL Thanks very much |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 22:59:15
|
| Not only that, have to add that disk as dependency of sql resource in cluster admin. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-08-15 : 08:55:16
|
| Thanks we did it ....glad i tested it out before tonight as i have to move databases tonight from one disk to anotherCheers |
|
|
|
|
|
|
SAN Error on database