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 |
|
Max_dona
Starting Member
4 Posts |
 Posted - 2010-12-16 : 05:57:43
|
| Hi everybody,I have configured a three istances SQL server 2008 in a clustered environment. I have added a storage using the cluster failover manager (precisely a 65 GB LUN) to one istance, because i wanted to putmy logs there. So my instance has two disks: one intended for the data and one for the logs. By connecting to the instance thru Sql Server Management Studio , i am not able to "see" the disk i have added...basically i can only see my data drive. i have tried to remove and re-add the disk again but without any measure of success :(Could someone please advise?. I am pretty a newbie.Thanks,Regards,Max from Italy |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-16 : 08:31:31
|
| Is the drive a cluster resource? Has it been set as a dependency of the SQL Service resource?--Gail ShawSQL Server MVP |
 |
|
|
Max_dona
Starting Member
4 Posts |
Posted - 2010-12-16 : 08:47:16
|
| Gail,Thanks for the answer...No..the dependancy report shows there are no dependencies for this resource.....how can i add the drive as a dependency for the istance?Thanks in advance,MaxMax |
|
|
|
Max_dona
Starting Member
4 Posts |
Posted - 2010-12-16 : 08:57:42
|
| I have set the drive as a dependency of the sql service....but still no results...:(Max |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-16 : 12:31:26
|
| Restarted SQL?--Gail ShawSQL Server MVP |
|
|
|
Max_dona
Starting Member
4 Posts |
Posted - 2010-12-17 : 03:45:53
|
| No i didn't.. do i have to restart the affected instance or all the service as a whole?Max |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-17 : 09:54:18
|
| Restart the instance that you're setting the drive as a dependency of. Odd, I though setting dependencies required the group to be offline.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Help needed