August 11, 2008 at 6:56 pm
Hi,
We have SQL 2005 64Bit Std edition installed in a cluster in pre-production environment. The disks (2, drive M and N) are on a SAN. When we failover from one machine to another, one drive follows (M) the other does not. I am relatively new to SQL server ... do we need and special configuration? What am I missing.
Thank you.
August 11, 2008 at 8:30 pm
antonio.varricchio (8/11/2008)
Hi,We have SQL 2005 64Bit Std edition installed in a cluster in pre-production environment. The disks (2, drive M and N) are on a SAN. When we failover from one machine to another, one drive follows (M) the other does not. I am relatively new to SQL server ... do we need and special configuration? What am I missing.
Thank you.
Using Cluster Administrator, verify that drive N has been setup as a resource in the same cluster group as SQL Server. Also verify that SQL Server has been made dependent upon both M and N.
You should have at least two cluster groups. The first group should be for the cluster only and will contain the Cluster Name, Cluster IP and quorom drive. The second group will contain all SQL Server related resources.
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply