Number of nodes for sql clustering
Thu, 26 Jun 2008 23:05:00 -0700
Hi,
i understand that the technology for clustering are N+1 or N+m. However, Can
1 deploy sql cluster nodes in odd numbers? Example, 3 nodes with
active/active/passive or 5 nodes with 3 active/2 passive ??
Many thanks!!
regards,
Windows Fan ...
|
SQL 2005 and Win2008 Multi-subnet clustering
Mon, 23 Jun 2008 12:03:18 -0500
Is this supported?
Details:
2-node Win2008 Ent. Cluster with multiple subnets. Able to successfully fail
back and forth no problem with one subnet coming online at one node and the
other coming online at the other node.
Install SQL 2005 Ent. and it won't come online with the non-active subnet
configur ...
|
Boot.ini
Fri, 20 Jun 2008 14:21:18 -0700
We have a 32 bit SQL 2005 active-active clusterd server, with 8GB RAM in
each node. What should we do with boot.ini?
1 /3GB
2 /PAE
3 /3GB /PAE
...
|
SQL 2000 Cluster (Active, Passive) E-mail
Fri, 20 Jun 2008 09:37:01 -0700
I need to setup SQL to automatically email out of report each night when it
is done, i've done it in the past on a stand alone server by just installing
outlook setting up a profile and setting the sql services to use that
account. Not sure how to do it in a cluster or even if outlook could be
installed on ...
|
SQL Server 2005 Service Pack 2
Wed, 18 Jun 2008 13:34:27 -0700 (PDT)
Hi All,
first of all thank you very much for your help!
I have two questions
I have a SQL Server 2005 on a Windows 2003 failover cluster. Both nods
are without Service Pack and I want to upgrate them to SP2 but I'm not
able to find a guide to understand if i have to run the setup on both
nodes or only on t ...
|
Error during installation
Wed, 18 Jun 2008 09:35:02 -0700
SQL Server 2005 Standard edition installattion.
Nodes are pingable from each as well as the cluster resource.
Installing from a local drive.
Recieved the following error during instalation.
Any ideas?
LinkID 20476
Product Name Microsoft SQL Server
Product Version 9.00.1399.06
Message Source setup.rll
Me ...
|
SQL server does not see newly added cluster drive resource
Tue, 17 Jun 2008 07:15:01 -0700
Hi,
I have added a new sql cluster drive resource into my cluster and brought
this online succesfully. However, SQL still cannot see this drive when I try
to add new database files.
Any ideas would be gratefully received! ...
|
|
|
SQL 2008 Clustering
Tue, 17 Jun 2008 00:12:31 -0700
is there a newsgroup which supports SQL Server 2008 failover clustering
based on RC0?
...
|
Active/Passive Cluster - Can the passive node be safely ustilised?
Mon, 16 Jun 2008 04:38:00 -0700
I am currently involved with a production environment that is made up of a
two node Acitive/Passive cluster.
I am conscious (and so too of course is the business) that the Passive node
is doing absolutely nothing, all of the time other than of course waiting to
take over in the event of a failure.
My que ...
|
Cluster IP address, Max number of nodes in a cluster
Sun, 15 Jun 2008 23:44:09 -0700 (PDT)
Hi,
I am using Failover Cluster API's to gather information about the
cluster. Here us tge URL http://msdn.microsoft.com/en-us/library/aa372859(VS.85).aspx
PROBLEM: I am not able to find any API which would return the IP
address of the cluster, maximum number of nodes supported by the
cluster.
My cluster i ...
|
