July 31, 2008 at 9:00 pm
SQL 2005 Enterprise SP2 64 bit on W2K3 Enterprise server SP2 64 bit.
I have a new 2-node SQL cluster that's connected to an iSCSI storage device. I have the following targets and drives created:
S: SQL data
K: SQL Backups
L: SQL logs
Q: Quorum
I've created a dependency for each drive and they can be viewed under my new Cluster Drives group in CLuster Administrator. When attempting to restore databases from within Management Studio I can only see my S: drive. So I do the following:
1. Open Cluster Administrator and navigate to my group.
2. Right-click S: and take it offline.
3. Modify the Dependencies list and add my L: and K: drives.
4. Bring everything back online.
I'm still unable to see the other drives. What am I missing? Should I reboot the nodes?
Any direction or assistance on this issue is greatly appreciated.
July 31, 2008 at 9:35 pm
Are you making the K:\ and L:\ drives a dependency for the S:\ drive or for the SQL Server resource? Your description sounds like the former.
K. Brian Kelley
@kbriankelley
July 31, 2008 at 9:58 pm
The end goal is to be able to see the additional drives from within management studio. So I guess I was under the impression that they needed to be dependencies for the S: drive. Is this not correct?
July 31, 2008 at 10:11 pm
No, they need to be dependencies for SQL Server. You need to take SQL Server offline - add the drives as dependencies for SQL Server and bring SQL Server back online.
Once that is done - you will be able to see the drives.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2008 at 10:18 pm
That did it! Thank you very much.
July 31, 2008 at 10:20 pm
Great - glad we could help.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply