Re: Nodes Resosources and Groups

Tech-Archive recommends: Fix windows errors by optimizing your registry



Do I need a Cluster Group for each instance?

On Apr 30, 12:41 pm, "Rodney R. Fournier [MVP]" <r...@xxxxxxxxxxxxxxxx
america.com> wrote:
Yes it does. Instance = SQL Server, it has its own master, model, msdb, and
user databases.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clusteringhttp://www.nw-america.com- Clustering Websitehttp://msmvps.com/clustering- Bloghttp://www.clusterhelp.com- Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

"Rick" <drummer10...@xxxxxxxxx> wrote in message

news:1177950936.713628.234330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



I'm am not sure at this time, does an instance count as another SQL
Server when trying to connect to a database?

Rick

On Apr 30, 6:26 am, "Edwin vMierlo [MVP]"
<EdwinvMie...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
How many instances of SQL are you planning of running in your cluster ?

"Rick" <drummer10...@xxxxxxxxx> wrote in message

news:1177927905.901037.314760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Building a 4 node Windows 2003 cluster for SQL. Have Luns on SAN
carved out for 3 Data, 3 Log volumes and 1 Quorum volume. Do I need to
setup a group for each (3) active nodes with a IP and Network Name
resource in each? will this look to the user as three different
servers due to three different network names?

thanks in advance
Rick.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -


.



Relevant Pages

  • Re: Nodes Resosources and Groups
    ... user databases. ... MVP - Windows Server - Clustering ... setup a group for each active nodes with a IP and Network Name ...
    (microsoft.public.windows.server.clustering)
  • Re: Failover problem when unplug the public connection
    ... Cluster Group contains three resources which are IP, ... Network failure detection and recovery in Windows Server 2003 Clusters ...
    (microsoft.public.windows.server.clustering)
  • Re: Migrating from standalone to sql 2000 cluster
    ... I like to do manual log shipping for the transition. ... You do a restore to the new server using the WITH STANDBY option. ... Master or MSDB databases, just the user databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Spam Control for Mail Relay
    ... all messages until there server becomes online again. ... why you need the relay in the first place. ... - off-line copy of destination servers' user databases on the relay ... on-line query of user database (eg. LDAP) ...
    (comp.mail.sendmail)
  • Re: active active windows 2003 clustering
    ... Cluster Group has 1 G shared storage for Quorum. ... Server 1 owns storage group with 4 stores ... >> cluster install on windpws 2003 server enterprise. ...
    (microsoft.public.windows.server.clustering)