MSA Storage
cancel
Showing results for 
Search instead for 
Did you mean: 

MSA 1500cs (Active/Active) - SQL Clustering - Drives on 2nd Node not working.

 
SOLVED
Go to solution
Mark Ervin
Occasional Advisor

MSA 1500cs (Active/Active) - SQL Clustering - Drives on 2nd Node not working.

Hi,

I'm having trouble trying to configure an SQL Cluster using the following;

MSA 1500cs (Active/Active)
2 x MSA 30
1 x MSA 20
2 x BL460c
Windows 2008 R2
SQL 2008 R2

The first server 01 is up and running and the 4 drives are presented fine. The cluster is on line and all databases are working. Ive built 02 in the same way and am using MPIO in windows to mount the drives. Everything appears OK apart from the drive status is an exclamation mark with:

Offline (The disk is offline because of policy set by an administrator)

If I leave the drives as they are I can restart the server fine and carry on as normal. If I manually bring the drives online the server will not boot agaian until I remove the access in the configuration utility. Another thing to note is the drives say reserved on the 01 sql box when looking at the properties.

Is it possible to have 2 nodes accessing the same luns on the MSA 1500cs?
Could it be there is some kind of lock on the MSA?
Is this a clustering issue or an HP issue?

Pretty stuck on this so any help would be appreciated.

Thanks,

Mark

8 REPLIES 8
Johan Guldmyr
Honored Contributor

Re: MSA 1500cs (Active/Active) - SQL Clustering - Drives on 2nd Node not working.

Hello, what file system do you have on the shared disks?
Mark Ervin
Occasional Advisor

Re: MSA 1500cs (Active/Active) - SQL Clustering - Drives on 2nd Node not working.

Hi,

The drives are NTFS. They are configured using windows MPIO. I have tried using the HP DSM in the MPIO manager to no avail.

To add, once the drives are first bought online manually after being presented they appear to come online but no drive letters are given or availabale to assign. It is after restarting then that the server will not boot.

Thanks,

Mark

Johan Guldmyr
Honored Contributor

Re: MSA 1500cs (Active/Active) - SQL Clustering - Drives on 2nd Node not working.

Hi, you should not access the same NTFS disk from two machines. If it works it will most likely cause corruption.
Check out CSV - cluster shared volumes. There may be other options as well.

http://en.wikipedia.org/wiki/Cluster_Shared_Volumes
Mark Ervin
Occasional Advisor

Re: MSA 1500cs (Active/Active) - SQL Clustering - Drives on 2nd Node not working.

Thanks for the link. It looks as though it may work as a solution for me. My only question is that as SQL will be running in active / passive so only one server will be accessing the disks at once. It is the initial mounting of the drives to setup the cluster I need to get around.

Are you saying it is just not possible or there are better ways of doing it?

Thanks again for your advice. I really appreciate it.

Mark Ervin
Occasional Advisor

Re: MSA 1500cs (Active/Active) - SQL Clustering - Drives on 2nd Node not working.

Also these are stand alone servers and not in a virtual environment.

Thanks,

Mark