Re: Installing SQL205 in a cluster with mount points

Dear Antonio,

Thanks for the info. The bit that is mssing from that document - at least I
cannot find it is how big the base drive has to be. As far as I can see what
is not mentioned is that the SQL 2005 installation will put some files in the
base drive. Most of the installation goes somewhere such as C:\Program
Files\.... but some files are put in the shared drive which is acting as the
base drive. I have tried creating the base drive with about 50 GB and SQL
2005 then installs. I don't know how much will go in there for different
installation choices but I am now trying a 30GB base drive to see if that is
big enough.

Anyway, to summarise, the base drive isn't just for mount points as the
document suggests but also holds quite a few installation files which I guess
need to be shared between the cluster nodes.

Best wishes....
Colin

"Antonio Soto" wrote:

Hi Colin,

This link has information about special mount point considerations
http://msdn2.microsoft.com/en-us/library/ms189910.aspx.

Regards

Antonio Soto
Solid Quality Leaning
http://www.solidqualitylearning.com

DISCLAIMER:
Anything written in this message represents solely the point of view of the
sender. This message does not imply endorsement from Solid Quality Learning,
and it does not represent the point of view of Solid Quality Learning or any
other person, company or institution mentioned in this message



"Colin Bruce" <ColinBruce@xxxxxxxxxxxxxxxxxxxxxxxxx> escribió en el mensaje
news:2DA833EE-D6B1-4D53-8E2B-4374B73F7F03@xxxxxxxxxxxxxxxx
I am struggling with an installation of SQL2005 on Windows Server 2003 SP1.
I
am trying to set up a 2 node cluster with a single instance of sql2005. I
need to use mount points so I create a shared disk for the mount points
and 2
disks which are mounted in there. The shared disk is called M: and the
other
disks have names (DB and Logs). There will be more in due course but I
thought I would start with 2.

The install proceeds okay until it gets to the point where I have to
choose
a cluster group to put it in. I have created one with M: in it plus the
two
mounted disks. However, when I select that one it insists in making M: the
destination for the data files and, of course there is not enough space
there
for them. It seems to be completed incapable of using the mount points. In
fact ir doesn't see them at all.

Does anyone know how to fix this or is it just not possible to use mount
points with SQL2005 in a cluster despite what the documentation says



.

Relevant Pages

  • RE: spcustom.dll being created on the clustered Disks
    ... The spcustom.dll and updater.exe are files that usually for the most get installed during a hotfix installation. ... If this is not causing a particular problem with the Cluster itself, then I wouldn't worry about it. ... spcustom.dll being created on the clustered Disks ... Servers are running Windows 2000 Advanced Server, ...
    (microsoft.public.windows.server.clustering)
  • Booting a poor-mans LAVC [was:Interesting cluster config "deadlock"]
    ... I managed an environment where a VAX with locally attached DSSI disks ... We also needed to retain cluster quorum. ... then tried to mount the shadow set with ...
    (comp.os.vms)
  • File Server Cluster Capacity
    ... I recently started with a new company and I've been put on the cluster ... carve 300 to 800 GB disks out of the SAN and mount them as disks in the ... file shares, etc. ... then create empty folders for Mount points. ...
    (microsoft.public.windows.server.clustering)
  • Re: Adding a node to a one-node functional cluster
    ... Until then, both nodes will try and mount them, typically with bad ... Once the cluster service writes an intentionally mangled ... > on the disks, the OS thinks they are foreign partitions and won't try and ... > requires so the new node can see the LUNs as well as the old node. ...
    (microsoft.public.sqlserver.clustering)
  • Re: chicken and egg: shadowing and licenses
    ... > On my systems, I mount all disks, be it shadow sets or plain disks, ... The cluster wide logical name LMF$LICENSE points to this file. ... > And I get no license warnings during startup! ... I mount the cluster-wide disk from SYLOGICALS.COM and mount other disks ...
    (comp.os.vms)