Re: SQL Clustering Active/Active Problem.

You must run the SQL installer to add or remove nodes from the SQL
configuration. Using the cluster administrator tool to add or remove
possible owners will not work. The SQL installer will adjust the cluster
group and resource properties correctly.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Cipher" <Cipler@xxxxxxx> wrote in message
news:Oxve$RZXGHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for your reply.
But from the beginning i already add for each resource in both sqlgroups
(SQLGroup1 & SQLGroup2) as Possible owners the 2 nodes ,and after that the
2 nodes as Preferred Owners for each sqlgroup

What do u mean by saying "You have to add
Node2 to the possible owners of SQLGroup1.This is only possible using the
SQL installer" ?
It confuses me little,how to achieve that?


Best Regards,
Cipher.

"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:OUjS%23rXXGHA.4924@xxxxxxxxxxxxxxxxxxxxxxx
Owners list the POSSIBLE owners, not the current owners. You have to add
Node2 to the possible owners of SQLGroup1. This is only possible using
the SQL installer. Once you have both nodes as possible owners of each
resource group, you can then set the preferred owner order.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Cipher" <Cipler@xxxxxxx> wrote in message
news:%23G4AlvVXGHA.4432@xxxxxxxxxxxxxxxxxxxxxxx
Hello to everyone,

I made a new SQL (2000 SP3) Activer/Active cluster in my company with
the below nodes scheme :

SQLGroup1 -->SQLCLUST1 -> owner node1
SQLGroup2 -->SQLCLUST2\SQLCLUST2 -> owner node2

When i try to failover SQLGroup1 to node2 or the same procedure for
SQLGroup2 to node1 , it failovers the Disk ,SQLIP,SQL Network Name
Resources but the resources
SQL Server,Server Agent and Server Fulltext failed and the whole group
returns to its owner 'primary' node.

I changed the max memory size to both sql servers ,i check to event
viewer and cluster log ,but i didnt find something information to help
me.
If anyone can help or suggests something,thnx a lot

Regards,








.

Relevant Pages

  • Re: Error Message Evicting a Node
    ... Make sure you have run the SQL installer and removed the node from SQL as ... Evicting the node rom the cluster does not clean up the SQL ... cleanup was not done". ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Clustering Active/Active Problem.
    ... I tried through the SQL Installer through steps: ... Install SQL Server 2000 Components ->Install Database Server ... possible owners will not work. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding a new node to a SQL server cluster
    ... Look up 'Maintaining a Failover Cluster'. ... You will need to re-run the SQL installer, but if you follow the steps ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • RE: Getting Multiple Owners Names for Single Pieces of Property
    ... I believe the standard answer to this type of question in SQL would be to use ... a subquery for the "Owners" field, then use CONCATENATEto merge the ... pre-generate an "Owners by HoueID" table, maybe temporarily, to get the ... FROM taDEFENDANTTYPE INNER JOIN ((taTAXSALESTATUS INNER JOIN (taCOURTDATA ...
    (microsoft.public.access.queries)
  • Re: Adding 3 nodes to a cluster
    ... The SQL installer allows you to add the new nodes as allowed hosts after you have joined the new nodes to the cluster. ... previous two node cluster to any of the new servers. ...
    (microsoft.public.sqlserver.clustering)
Loading