Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server clustering > february 2004 > threads for february 15 - 21, 2004

Filter by week: 1 2 3 4

Cluster Design
Posted by nexus99 at 2/20/2004 2:33:28 PM
Hi all We are planning to set up the following Cluster design 4 nodes running 2003 EE and SQL 2000 EE. 2 active nodes and 2 passive for fail over. (In the futre a couple more active nodes will be added. Behind the cluster will be an EMC Calriion SAN. All nodes will have 2 HBAs connected to the...more >>


SQL standard on cluster?
Posted by dw at 2/20/2004 11:13:37 AM
I know that standard edition doesn't support Clustering, but my question is, can we still install SQL server Standard edition with the processor licenses on one of the Clustered servers and not use the clustering capability? Will this even install correctly and if it does, is the licensin...more >>

how many servernames/clusternames
Posted by Hassan at 2/19/2004 2:38:26 PM
Setting up a 2 node cluster with SQL 2K on Win2k3. How many servernames/clusternames(virtual servernames) do I need ? Upon setting up with windows clustering MSCS , i need to create a virtual name right and have a virtual IP ? Do I also have to create another virtual name and another virtu...more >>

one node crashed need to rebuild quick
Posted by billet at 2/19/2004 11:51:08 AM
I have a two node cluster. One node has crashed and I need to know the best approach to rebuild the second node. In my case the node crashed from a hardware failure. This client did not have a good backup of the system state for this node. But I have a working node up and still running. We have evic...more >>

Raid 1 vs Raid 5
Posted by Eric Ward at 2/19/2004 6:11:05 AM
Should I run my transaction log on Raid 1 or Raid 5? How about the data file Right now I have them both running on Raid 5 Thanks for the help....more >>

Maximum nodes on Windows 2003
Posted by Pierre_Destrée at 2/19/2004 2:17:09 AM
Hi am looking how many nodes SQL Server is supporting with Windows 2003 depending of the version : 1. Windows 2003 Enterprise with SQL Server 2003 Enterprise and a traditional quorum 2. Windows 2003 Datacenter with SQL Server 2003 Enterprise and a traditional quorum 3. Windows 2003 En...more >>

Clustering SQL 2000
Posted by Olutimi at 2/18/2004 3:13:37 AM
I have a two-node SQL2k active/passive failover cluster on WIN2k ADV SP3. I would like to install a new instance of SQL2k for another application in the failover cluster. Please advice. Help appreciated...more >>

Windows Server 2003 Cluster Configuration
Posted by Robert at 2/18/2004 3:06:07 AM
We would like to setup a two node cluster using windows server 2003. We do NOT have a shared, block-level disk device to use for the quorum disk. Windows Server 2003 however provides an alternative, optional quorum mechanism that is known as the majority node set. The question is: Can this mechanism...more >>



Identity
Posted by M A Srinivas at 2/17/2004 10:56:07 PM
We are going to implement Cluster Server on Win 2003 SQL 2000 SP3 Application is web based and there are some batch process . Need clarification on this 1. If the active node fails and when second node takes over , and if users are modifying data , what happens to these modifications. Bas...more >>

SQL Server Clustering
Posted by azarazaga NO[at]SPAM goldcomm.com at 2/17/2004 2:54:31 PM
Hi, I have a 4 Gb RAM , 2 Xeon processors machine running SQL Server 2000. I have a large number of records and it seems to be collapsed. I would like to upgrade this configuration , and someone told me about clustering the database. What I would like to know is : - Is a active/active sql clu...more >>

build order of cluster service and patches
Posted by Samm at 2/17/2004 2:46:10 PM
We're in the process of building new servers. One would be Win2k Advanced, Cluster Service, and SQL 2k Enteprise. The question I have is what's the install order I need to take. My intended order is: 1. Win2k Advanced 2. Cluster Service 3. Win2k SP4 4. Patches released after SP4 5. SQL 2k ente...more >>

domain controller in cluster server
Posted by Li at 2/16/2004 5:29:17 PM
Hi, I am planning to install two nodes clustered sql server, should I install domain contraoller in both nodes with one is PDC and another is BDC?or it has to be PDC only? ...more >>

Two drives that will not failover on failure
Posted by Mike at 2/16/2004 12:52:23 PM
This is a Windows 2000 Advanced Server that is clustered with SQL Server 2000 with SP3A. This is a Active/Active Cluster setup with a A and B node. I have two drives that will failover to other node on a failure. On a test we failed the server which caused the SQL Server, SQL Agent, SQ...more >>

MSDTC, Win2K3EE and SQL2K
Posted by David Pendleton at 2/16/2004 10:58:46 AM
Hello all. We've just built a Windows 2003 EE active/active cluster. SQL Server 2000 is installed on each node. MSDTC was installed after-the-fact and is not working properly, i.e. working for some applications, not for others. MSDTC was originally set up in one of the SQL Server Groups, del...more >>

how to add mssearch to cluster
Posted by yuhong wu at 2/16/2004 9:59:10 AM
now I had a cluster ,want to add mssearch serive to the cluster,because our sqlserver need to use fulltext,but when I add it to the cluster,the cluster will change to another server immedialtly,but it find the service can't run at the server ,so it change to the former server too,and such happens...more >>

Database on different Array and disks
Posted by franco at 2/16/2004 5:44:58 AM
Future Environment: Cluster of 2 node IBM x445 4 CPU 2.0 GHZ 4GB Memory each server. 1 Controller IBM FastT700 with 2 EXP700. 26 FC-HDD 74GB 15K in RAID 1 + 2 Hot Spare Tape and so on... I am in the process of configure this new cluster and I have a question about where to place db files ...more >>

Attach Error
Posted by Eric Ward at 2/15/2004 10:26:59 PM
We had a hard disk fail which caused our SQL 2000 database to turn gray and say 'Suspect'. I detached the database and tried to reattach it. I get the following error every time I try to reattach it: Error: 823, Severity: 24, State: 2 I/O error (bad page ID) detected during read at offset 0x00...more >>

Cross over cable for private n/w
Posted by Hassan at 2/15/2004 8:46:11 PM
Why do we use a cross over cable and not a straight cable for the private n/w of a cluster? What is the difference between the 2 ? ...more >>


DevelopmentNow Blog