Hi,

We have a 4 node SQL 2005 64bit EE (sp2) cluster with 6 SQL instances (OS
Windows 2003 EE 64bit). The storage is EMC CX400 SAN. Each instance has one
mount point and there are data, log, system and temp SAN volumes mounted
under the mount point.

We are having some strang problems. Sometime after an instance is offlined,
it cannot be brought online and the mount point (say F will show as failed.
As a result all the voulmes (data, log etc.) and sql instance will be
offline. I am saying it is strange as this does not always happen. Most of
times it comes back online ok. And if it does not come back online, we would
reboot the node and the group will failover to other node successfully, and
then it can be failed back to the node without problem.

Does anyone have any idea why this is happening and possible fixes?

Thanks so much.
--
Brian

HI Brian,

Can you see if there an any error in Event log under System? If so can
you please list those messages when disk failure does happen?

On top of head I am thinking issue with the SAN and server? Does it
always fail on the same node?
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Brian Brian" wrote:

When you use mount points, the SQL installer does not always set
dependencies correctly. Make sure that the dependency chain is correct so
SQL does not come online until all the mount point disk resources are up.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Brian Brian" <BrianBrian (AT) discussions (DOT) microsoft.com> wrote

Hey Geoff,

Do you know any way to do dependency across resource groups? On one of
our SQL Servers they (Server Guys) had put the backup drive in a different
resource group; and I would like to make sure that resource gets move with
the resources in the primary group where SQL Service and other drives are?

Do you know of a way to do that? Or I have to move the resource over?
Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Geoff N. Hiten" wrote:

By definition, clustering does not allow dependencies across resource
groups. That is the whole premise behind "shared nothing".
I usually back up to UNC shares across a network. You can host them on the
same cluster, just create a file share with that disk device, remove it from
any SQL server group, and access it via UNC.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Mohit K. Gupta" <mohitkgupta (AT) msn (DOT) com> wrote

Thanks thats what I have on another cluster; this new one I wasn't involved
in setting up. So I wanted to be sure before I submit paper work to change
stuff..

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Geoff N. Hiten" wrote: