Re: SQL 2005 clustered virtual server

Tech-Archive recommends: Speed Up your PC by fixing your registry

Does each resource group require its own quorum disk?

Does this mean I need a seperate disk for each instance of SQL? I have
heard something about mount points - what exactly is this and can I use this
instead?

I will have about 8-10 instances running on the cluster.

Thanks,
Neil Paddock.

"Chuck Timon [MSFT]" wrote:

Correct. Only one SQL instance per resource group. So, you will need to
create another resource group with some physical disks in it (at least one)
and then select that group when you create your next instance.

Chuck Timon, Jr.
Microsoft Corporation
Longhorn Readiness Team
This posting is provided "AS IS" with no warranties, and confers no rights.




"Neil Paddock" <NeilPaddock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6D5CC6BF-0BBF-467D-B001-ABE7DBECD5D0@xxxxxxxxxxxxxxxx
Hi Chuck,

On your advice, I have successfully installed the first instance of sql
2005. When I go to install a second instance, when I get to the "Cluster
Group Selection" window, I get the message "Group 01 - Already contains a
SQL
Virtual Server"

Am I doing something wrong?

Thanks,
Neil Paddock

"Chuck Timon [MSFT]" wrote:

One for each instance will be created when SQL setup is run.

Chuck Timon, Jr.
Microsoft Corporation
Longhorn Readiness Team
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Neil Paddock" <NeilPaddock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:95D572AD-899D-4A36-B2A7-609DCB4930F2@xxxxxxxxxxxxxxxx
I am setting up a 2 node 2003 enterprise cluster. I need to install a
number
of SQL 2005 instances on to the cluster.

Do I need a virtual server for each instance or do I create one virtual
server which contains all instances of SQL 2005?

Many thanks,
Neil Paddock.




.

Relevant Pages

  • Re: New to clustering and need some clarification on disk resource
    ... "Geoff N. Hiten" wrote: ... second node, only the primary, during a cluster install. ... Senior SQL Infrastructure Consultant ... enough disk space for all your data. ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to clustering and need some clarification on disk resource
    ... The clustered disk should have MDF and LDF files. ... Did you look at the SQL setup logs to see what went wrong? ... Microsoft SQL Server MVP ... running, quorum is clustered and running, cluster is healthy and i got 29 out ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 clustering with Windows 2008
    ... If I configured SQL first, during the SQL clustering installation/Setup, I ... MSDTC configuration later. ... I went on to set up MSDTC and set its dependency to disk E. This step ... I move disk E back to the 'SQL resource group'. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 05 ENT Cluster: not enough disk space for data files
    ... X:\Microsoft SQL Server ... I did notice that for some reason my drives are accessible (not just ... visable) to both cluster nodes (and its an active passive, ... These is not enough disk space on the destination disk for the current ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 extra instance into same group
    ... There is a trace flag that will disable the disk dependency check, ... If you had multiple instances running in the same resource group, ... If one were to fail, ... Every instance requires its own group/disk/IP/networkname in a cluster. ...
    (microsoft.public.sqlserver.clustering)