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 > october 2003 > threads for october 29 - 31, 2003

Filter by week: 1 2 3 4 5

Multi Clusted Named instances.
Posted by Steve Schofield at 10/31/2003 11:37:38 PM
I have an Win2000 Active/Active Cluster running SQL 2000. Each side of the cluster is running its own named instance of SQL 2000 Enterprise. Side A has two physical disks F:\ and G:\, Side B has H:\ and I:\. physical disks. The I:\ drive has enough space to house another instance. The clus...more >>


Cluster resource SQL Server (InstanceName) failed to come offline
Posted by JBailey at 10/31/2003 11:05:25 AM
I have a 2 node cluster with 3 instances of SQL. One specific instance, when I attemtp to take it offline produces the following error: In cluster administrator is shows the SQL Server Resource as Failed Event Viewer produces the following: Source:ClusSvc Event ID: 1117 Description: Clus...more >>

FT status shows "Populating" but process seems to be idle
Posted by ricardo NO[at]SPAM netvita.pt at 10/30/2003 2:35:24 PM
Cenario: ========================================================= Server: Clustered Windows 2000 Advanced Server SP4 DB : MSSQL Server Enterprise Edition, SP 3, version 8.0.0.760 Instaled services: MSSearch, SQL Server, Agent, T-Transaction - All services instaled, and online in cluster mana...more >>

Event ID 17055
Posted by JBailey at 10/30/2003 2:09:14 PM
We have a 2 node windows 2000 active/active cluster running with 3 instances of SQL 2000. I have set the memory up for each as follows: Sp_configure 'show advanced options',1 RECONFIGURE GO Sp_configure 'awe enabled',1 RECONFIGURE GO Sp_configure 'min server memory'...more >>

About memory usage
Posted by Jenny at 10/30/2003 1:58:54 PM
Hi All, We have active/active Cluster setting on Microsoft Windows 2003 DataCenter Server. Installed SQL Server 2000 with SP3, used AWE to configured max server memory to 3072(MB) and the 3 GB switch in the Boot.ini file. From SQL Server Properties, it selected Use a fixed memory size...more >>

SP3a for SQL2K on W2K3 cluster
Posted by Owen Thomas at 10/30/2003 11:08:52 AM
I am trying to upgrade an SQL2K instance to SP3a on a Windows W2K3 cluster .... without success. I am able to sucessfully navigate through the various setup screens (using the setup.bat installation), that select my virtual SQL instance, sa username and password. However after I select OK...more >>

Experimenting with clustering
Posted by crbd98 NO[at]SPAM yahoo.com at 10/30/2003 8:53:08 AM
Dear Friends, This is new environment to me. Therefore, I would appreciate your comments and suggestions. This is the scenario. I have two SQL servers 2000 (standard edition) connected to a shared storage. I moved all the database files to the shared drive. To my surprise, I noticed that...more >>

Replication problem SQL 2000
Posted by Ripul Handa at 10/30/2003 12:22:27 AM
Hi, I am trying to run replication on SQL 2000. Replication was running fine on the SQL cluster. Ever since I added 8 to 9 tables in the replication it started giving me some problem. I removed those tables but still it didnt help. I disabled the replication and created again but while ...more >>



Check sql 2000 service pack
Posted by Ripul Handa at 10/29/2003 10:49:20 PM
Hi, I am running SQL 2000 server. How can I check which serice pack is installed on this server for SQL. I am new to SQL so please help Regards Ripul...more >>

Installing a SQL2K on a W2K3 cluster
Posted by Roberto at 10/29/2003 8:32:10 PM
Hi, I'm trying to install a SQL2k Server on a W2k3 based cluster fails. Following the instructions of the article 815431, Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails, I can't resolve my problem. I receive the "Setup failed to perform ...more >>

Error Installing SQL2k on a W2k3 cluster
Posted by Roberto at 10/29/2003 7:50:29 PM
Hi, I'm trying to install a SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails. Finally, I follow the step shown at the article 815431 where you can find how to install a named instance of SQL2k in a W2k3 cluster. But it's imposible to use the same virtual server name and inst...more >>

HELP: Hard Disk Upgrade for SQL Cluster
Posted by Travis at 10/29/2003 3:47:17 PM
Background: I have inherited a new SQL infrastructure based on a 2 node SQL Server 2000 cluster and an HP StorageWorks Modular SAN Array 1000. The SAN was configured with (14) 36GB drives arranged in 2 arrays. The first array is attached is 12 disks arranged in a RAID 5 config. The las...more >>

SQL Server Agent 7.0 (SP4) Fails on second node
Posted by devivo30 NO[at]SPAM hotmail.com at 10/29/2003 11:22:02 AM
Hello, I have read through many messages with similar subjects to this one I'm posting, but I haven't been able to find any solutions that work for my problem. I have a Windows 2000 SP3 Cluster running on a Compaq Proliant CL380 with SQL Server 7.0 installed. I've just recently "inherited"...more >>

Multiple Instance ??
Posted by Todd Day at 10/29/2003 7:26:12 AM
Hello, We are setting up a 2 server active/passive SQL 2000 and Windows 2000 Adv cluster, each server has 2 GB of memory. Currently we have 2 databases with a third on the way. The databases should be 20GB or less with decent read/write activity. My question is, should we run a separate instance ...more >>


DevelopmentNow Blog