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 > september 2004 > threads for september 15 - 21, 2004

Filter by week: 1 2 3 4 5

Upgrading Question
Posted by Chip at 9/21/2004 8:50:22 PM
Hi, We are in process of upgrading all Win2k boxes with 2 node clustering which includes SQL server 2000 failover clustering to Win2k3 2 node clustering. What are the pros and cons. pls point me to some resources or share your personal experiences. Thanks Chip...more >>


Database Restore
Posted by Bob Smith at 9/21/2004 8:19:04 PM
I have a SQL cluster I built about two weeks ago on Windows 2003, now we are trying to restore a database to the server from a different location (non cluster) and we are unable, database seems to go but sql manager states the database is in a still loading state, is there anything I have to d...more >>

SQL 2000 on Win2k3 Unable to Install
Posted by news.sunrise.ch at 9/21/2004 6:45:04 PM
Setup Failed to Perform Required Operations on the Cluster Nodes I try to setting up a cluster on two Dell with EMC SAN drives with no success. I have tried everything it's a nightmare. Logfile: 18:28:12 szModifiedList = 18:28:12 szRemovedList = 18:28:12 End Action DialogShowSdVirtualSer...more >>

SQL 2000 on win2k3
Posted by Colemont Bert at 9/21/2004 5:24:08 PM
help! We are running a win2k3 cluster with sql2000, MSDTC seems to be running, and it is added in the cluster resource. I have done the dtctester and I get this result Password: 1paSS4twf tablename= #dtc25732 Creating Temp Table for Testing: #dtc25732 Warning: No Columns in Result Set From Ex...more >>

Dtabases over multiple instances
Posted by at 9/21/2004 2:42:18 PM
Hi all, For performance reason, I want to devide all databases over multiple instances. Say 3 instances in a 4-node cluster(win2K3).Active/Active/Active/Passive In this case, the application would need to know on which VirtualServer/Instance the database resides. If there is no way to tell...more >>

nic failover
Posted by Calvin Do at 9/20/2004 10:55:42 AM
Hello, when i purposely cuase a failure of the public nics, why doesnt my node1 failover over to node2? is this by design or is there something i can set in cluster administrator to do this? thank you calvin ...more >>

Query
Posted by Sachi at 9/19/2004 10:23:02 PM
Hi, We are planning to make clustering with our SQL Server database in our main servier. But I heard once it is been done, all the application which is point to this database should be rework. Is it true?If soo how is it? Regards, Sachi ...more >>

I CANT INSTAL a Virtual Server of SQL 2000 Enterprise in Win2k3 Enterprise
Posted by Alejandro Garreta at 9/18/2004 11:15:07 AM
I have a Cluster of Windows 2003 Enterprise Edition, When I try to install a SQL 2000 Enterprise Edition the setup option of Virtual Server appear unavailable I only choose between Local Install or Remote. Thanks for your help ...more >>



setup MSDTC on live (production) cluster
Posted by cmiller NO[at]SPAM crea.ca at 9/17/2004 6:58:23 AM
Morning, We are running Win2k AD. Ed. SP4 and SQL 2000 SP3a Failover is working fine, and now MSDTC service is required. What are the safest steps to take to setup MSDTC on a live envirmoent? Thanks Carmen...more >>

Comclust.exe Windows 2003 Server
Posted by Mark P. at 9/17/2004 4:57:21 AM
From what I have read you do have to apply COMCLUST.exe to a Windows 2003 Server on a cluster server with SQL Server 2000 Enterprise? If this is not correct, I have already loaded Windows 2003 Server on a cluster with SQL Server 2000 Enterprise. How would I correct this problem? Tha...more >>

MSDTC
Posted by Calvin Do at 9/16/2004 5:18:18 PM
hello, is MSDTC required in order for a 2003 sql cluster to work correctly? ...more >>

Problem when failing over to second Node
Posted by Tim Johnson at 9/16/2004 12:40:09 PM
I recently moved a cluster out of a one domain to the next. Worked through all the issues and I am still having a problem I can not seem to resolve. When I try to fail over to the second node, I see that SQL Network Name(virtualnamegiven)in cluster administrator fails. When I look in even...more >>

active/passive cluster with san drive
Posted by jay mack at 9/16/2004 10:59:32 AM
is there anywhere i can get a step by step order for installing an active/passive sql2000 cluster on a win2k3 platform that shares an attached san drive. i have not performed this before and am not sure about how to set up the san drive. do i set up the disks on one or both systems. or do ...more >>

Active/Passive Production with Test Instance
Posted by Dan D at 9/16/2004 8:25:10 AM
I am trying to setup a SQL cluster with the an active/passive cluster for production. On the passive node, I have been told to create a separate disk and install a developers edition of SQL to use as a test environment. The developers edition will be a named instance of SQL to help isolate...more >>

active/active clustering
Posted by ilkozer at 9/15/2004 5:39:50 PM
in an active/active clustering, do the two nodes have the instance of sqlserver with the same name ? can we say that we were serving on two hosts load balancing ? thanks ...more >>

do I need a domain in order to run a cluster?
Posted by Christos Kritikos at 9/15/2004 12:00:21 PM
Hi, I am a complete newbie with windows clustering - still reading the white papers etc. From what I have read it seems that I need a Windows Domain in order to run clustering. Is this true? Is there any way I can cluster SQL server without having to setup a domain? thanks christos ...more >>

Notification of Failover
Posted by marine at 9/15/2004 10:43:49 AM
I am running a multiple instance cluster. Each server has 8 CPUs with 16GB ram. I have a database on each server active where if one node fails, they failover to each other. Any documentation or information for instant notification when there is a failover? Notification by email etc. ...more >>

Cluster not responding
Posted by David Allday at 9/15/2004 4:51:10 AM
We have been having a problem where the cluster controller does not get a response from the SQL Server from the "are you alive" request ( select @@SERVERNAME ). It seems that the SQL server does not respond within a couple of minutes and the request times out. The Cluster controller then ...more >>


DevelopmentNow Blog