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 > january 2004 > threads for january 22 - 28, 2004

Filter by week: 1 2 3 4 5

Re-apply Service Pack after new node is installed?
Posted by P. Carignan at 1/28/2004 1:30:22 PM
I had to build a new node to replace a crashed node in my SQL cluster. After installing MSCS & SQL, I can transfer my resources from one node to the other. But, SQL has some problems. Looking at the files, I see SQLSERVR.EXE to be a different version on each servers. Do I need to...more >>


Problems with restore and backup database sql 2000 on W3K
Posted by hmendez at 1/28/2004 9:36:06 AM
Hello, I have sql 2K on cluster Windows 3K but when i do a backup report this message on eventlo Event Type: Erro Event Source: MSSQLSERVE Event Category: (2 Event ID: 1705 Date: 1/26/200 Time: 9:21:33 A User: N/ Computer: JUPITE Description 18204 BackupDiskFile::OpenMedia: Backup ...more >>

Client connectivity
Posted by Kirit Randeria at 1/27/2004 11:31:35 PM
How to set the idle timeout for the idle client connection ? ...more >>

Problem adding "Physical Disk" Resources to Groups
Posted by Michael [multnomah] at 1/27/2004 11:00:41 PM
We have a Windows 2003 EE Cluster Node [QAT2] that has an attached NAS device via iSCSI for disk storage. Previously, we had two large NAS partitions, drives K: [DATA] and L: [LOG]. Then we decided that we wanted to have 3 Virtual Servers, so we split up the partitions into 6 drives [3 DATA a...more >>

Node1 no longer sees MS SQL Server
Posted by scottf at 1/27/2004 6:46:44 PM
I recently upgraded our server to a 2 node cluster. We installed MS SQL server, and created the virtual server necessary for the cluster failover to work. I noticed today that I can not use SQL Enterprise manager from Node1. It does not see the instance of SQL Server. Under Server Groups i...more >>

SQL Cluster and update Jet 4.0 to SP8
Posted by Chris at 1/27/2004 1:04:16 PM
Request for info on updating only Jet 4.0 to SP8 on a SQL 2000 sp3 cluster. Does each node need to be done separately or does in recognize that it is in a clustered environment....more >>

missing drives
Posted by Mirna at 1/27/2004 11:06:13 AM
The servers are W2003 Enterprise SQL is 2000 Ent sp3a Active/Passive I just finished configuring the cluster and it looks fine except SQl does not see all drives. In other words when trying to create the database in enterprise manager server does sees only one drive. It bahaves the same w...more >>

IP Address used for xp_cmdshell?
Posted by Kevin at 1/26/2004 4:17:50 PM
I have SQL Server 2000 with SP3 running on a windows 2003 cluster. I need to setup log-shipping from a SQL Server 7 database server. The 2 servers are separated by a firewall. The guy that configures the firewall doesn't want to do trial-and-error to figure out which IPs to open up. I ...more >>



Looking for a Win2003 Cluster/SQL 2000 Whitepaper
Posted by Michael Bates at 1/26/2004 11:57:55 AM
I am having a hard time finding any details/caveats with installing SQL 2000 on a Windows 2003 cluster. Can anybody point me in the right direction? Thanks! Michael Bates...more >>

Setup Failed
Posted by Fred Jean at 1/26/2004 11:15:38 AM
Hi, I'm trying to install a second instance of SQL Server on a clustered node, from Node B. I had to cancel the first execution of setup installation program for different reasons. After that, we haven't been able to delete /Binn directory of that instance on Node B (sharing access vio...more >>

More than 1 SQL instance in a node?
Posted by Benny Koh at 1/25/2004 8:56:05 PM
My boss tells me to install 2 SQL instances on each node. This means 8 instances on 4 nodes. His reasons: a) Rather than 1 instance with databases having both high and low transactions, better to split into 2 instances, 1 with high usage databases, and the other with lower usage databases. CPU and...more >>

Different SQL Server Service packs in the cluster?
Posted by Carlos Gonzalez - Phoenix, AZ at 1/23/2004 2:31:04 PM
Can a virtual SQL Server 2000 SP2 and a virtual SQL Server 2000 SP3a coexist in the same Windows 2000 Datacenter cluster? Will the different versions of MDAC coexist in each node?...more >>

ADO Connection Problem with Port in Network Address
Posted by Sue at 1/23/2004 12:11:41 PM
We just installed a new SQL Server 2000 Active/Active cluster. We are trying to connect to the database from VB using ADO using the connection string: Provider=sqloledb;Data Source=HAZXXXXX\SDXXX;Network Library=dbmssocn;Network Address=172.99.99.99,1433;Initial Catalog=<DatabaseName>;Us...more >>

email notification from the clustered SQL Servers
Posted by Cata at 1/23/2004 11:18:43 AM
Hi, I am new with the SQL Server clustering, what do you recommend for jobs notification?...more >>

Setup failed to perform required operations on the cluster nodes.
Posted by John Marks at 1/23/2004 10:39:17 AM
Thannks in advance for an help on this. I am attempting to set up SQL2K EE on Win2003 cluster (active/passive). I get this error msg "Setup failed to perform required operations on the cluster nodes." during the install process. I have looked through the newsgroups and knowledge base...more >>

Add a node problem
Posted by Paul Dube at 1/22/2004 2:14:04 PM
I have a problem with my SQL cluster. One Windows 2000 server had a disk crash recently so I decided to reinstall it all under Windows 2003. So now I have the new Windows 2003 server and the good old Windows 2000 server. Let's call my servers SQL1 (Windows 2003) and SQL2 (Windows 2000). I i...more >>

Failover doesn't work properly whith network problems.
Posted by Chris Carmichael at 1/22/2004 11:56:05 AM
Hello All, We have a SQL cluster in active/passive configuration. Unfortunately, our network has been having issues. More specifically, the line protocol on the Cisco 3550 that the primary node on this cluster is connected to seems to drop off temporarily from time to time. So the problem ...more >>

Log Files on a Cluster Resource
Posted by Greg Boyle at 1/22/2004 9:39:24 AM
I have the following configuration 2 IBM x335 1 FASTT200 HA 1 Disk Array RAID 10 - 1 Partition (Drive S:) 1 Disk Array Raid 1 - 2 Partitions (Drives Q: & L:) The q: Drive and l: drive being 1 physical cluster resource, the sql server will NOT let me place the SQL Logs on the L: Driv...more >>


DevelopmentNow Blog