Re: Installation fails when creating virtual resource on node

Thanks for the disk recommendation. I had planned on using the Quorum as my
MS DTC disk resource.
I have actually tried both methods of setting up a resource group for MS DTC
and I have have tried using the Q drive also. None of these resolve my
original problem: the SQL Server installation is failing when
creating/bringing online virtual resources.
Is there an explanation/resolution for this? I have most recently tried
using an alias via named pipes, but this is not the solution either.

Thanks in advance

Dale


"Anthony Thomas" wrote:

> Actually, you will need three seperate Cluster Resource Groups. Each group
> will require its own Disk, IP, and Network Name resource:
>
> 1. Cluster Group: Quorum Disk.
>
> 2. MS DTC Group: MS DTC Disk.
>
> 3. SQL Server Group: SQL Server Disk(s).
>
> Although, you can get by with just one disk for both the Quorum and MS DTC,
> Microsoft recommends placing the MS DTC in its own reource group.
>
> Furthermore, you will want at least three Disk resources for the SQL Server
> group: one for your data, one for the transaction logs, and one for database
> backups.
>
> If your installation will be supporting multiple databases and/or a high
> transaction volume, you may also want another disk to seperate out the
> TempDB database data files and transaction logs from the other databases.
>
> Sincerely,
>
>
> Anthony Thomas
>
>
> --
>
> "DaleDBA" <DaleDBA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:50396684-C9B2-46D9-9F71-31EC9F3F21AD@xxxxxxxxxxxxxxxx
> Yes there is 1 other disk resource other than the Quorum.
>
> "Luca Bianchi" wrote:
>
> > DaleDBA wrote:
> > > Firstly, my MS Clustering service is installed and working. It is a
> > > 2-node cluster. Both nodes have MS Windows 2003 Enterprise Edition
> > > SP1 installed. The only cluster resource I have defined is a
> > > physical Disk, which is connected via SAN to a Fibre Channel Shared
> > > Disk Array.
> >
> > Is this the quorum disk or the disk that you will use for SQL Server
> > instance?
> > Is there another disk resource other than the quorum disk?
> >
> > Bye
> >
> > --
> > Luca Bianchi
> > Microsoft MVP - SQL Server
> > http://mvp.support.microsoft.com
> >
> >
> >
>
>
>
.

Relevant Pages

  • Re: Looking for suggestions on specs
    ... in the documentation I see that the quorum can be a relatively small ... if for some odd reason the DTC fails, ... In my opinion I would leave the cluster group the cluster group, ... As you are in a SAN, it should be possible to present a small disk to this ...
    (microsoft.public.sqlserver.clustering)
  • Re: I need dumpcfg.exe
    ... Administrator to do it, right-click on the cluster name, properties, Quroum ... This will safely move your quorum to whatever disk you choose. ... > "Replace a physical disk resource" and got no joy. ...
    (microsoft.public.windows.server.clustering)
  • Re: MNS disk problem
    ... disk resource ... MNS is only for quorum, e.g. the quorum is not on an disk/storage ... have two 120 GB IDE disks, no external storage, and two NICs. ... cluster with no errors but when I try to register a phisical disk resource ...
    (microsoft.public.windows.server.clustering)
  • Re: adding disk
    ... Temporary resource group, not temporary disk resource. ... Microsoft SQL Server MVP ... Present LUN to Host computers via SAN Masking software ...
    (microsoft.public.sqlserver.clustering)
  • Re: Single node cluster physical disk issue
    ... single node cluster?? ... I am experiancing an issue with "Bring Online" a physical disk resource. ...
    (microsoft.public.windows.server.clustering)
Loading