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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|