Hi guys, i am running a mission critical financial system on sql 2000 active/passive cluster. right now i have only cluster failover and transactional replication for reporting as disaster recovery mechanism. i want to implement a solution which will allow me to recover 100 % DATA with min...more >>

I have a two-node Active/Passive SQL Server Cluster on Win2k AS and SQL2000. When I attempt to manually failover to node 2 of the cluster all of the resources go over except SQL Server. The cluster log reports an Error 435. 'SQL Server failed to start'. I've just noticed another error ...more >>

We are running SQL Server 2000 Enterprise Edition [on Windows 2003 EE] on our PRD SQL Server Cluster. We have two nodes, PRD1 and PRD2. PRD1 will have one Virtual Server [and corresponding named instance], and PRD2 will have 3 Virtual Servers [and corresponding named instances]. So, my quest...more >>

Can Exchange Server 2000 & SQL Server 2000 can be installed in one cluster group? I have 2 node cluster and I plan to install both Exchange & SQL Server 2000 on it. Is this advisable to do? Thank you very much and more power!...more >>

Hi GUYS, in my sql server recently i am getting high Avg. Disk Queue Length of 40 for an array of 4 disks in every 5 minutes for around 20 sec and during this period the server performance is poor. any ideas? thanks Biju...more >>

Environment: SQL Server 2000 SP3a on W2K Advanced Server SP4. 1 IBM Server x440 with FastT700 Storage (Fibre Channel) We need to buy another IBM Server x440 or x445 and we would like to make a cluster. Question 1: Once we build the Cluster with the installation of the Cluster Service, mak...more >>

Hello. We have a QAT SQL Server 2000 2-node Cluster running on Windows 2003. The first node, QAT1, has a single Virtual Server [with a corresponding Named Instance]. The second node, QAT2, has 3 Virtual Servers [with 3 corresponding Named Instances]. What method can we use to estimate how m...more >>

Question: How to Clustered both SQL Server 2000 and MS Exchange in One Server? You know I have a machine server which i would like to configure MS Exchange in same manner of SQL Server 2000 that have shared storage. I mean computer A connect to virtual shared storage and computer B connect...more >>

Scenerio: I have an active/passive 2-node clustered SQL Server. I am connecting to the virtual machine via Computer Manager and creating a local group and then adding the appropriate global users/groups to this local group. I then grant database access to this group via SQL Enterprise Manager. ...more >>

I=B4m trying to install a SQL cluster, the description of=20 the environment is: Servers x370 IBM (4xPIII 700 MHz, 2 GB RAM, FC) FAStT200 Storage Server (SAN in FC) I install the machines from scratch, after the=20 installation of MSCS I made some test to verify the=20 operation of Cluster. ...more >>

Hello, I currently administer a two node active active cluster running Window NT 4.0 Server with SQL Server 7.0. Can anyone please explain to me what may be causing this particular problem? The Scheduler 3 appears to be hung. PSS 0x5277F110, EC 0x5F0FE084, UMS Context 0x01894F70. The Sche...more >>

We have 2003 server and cluster running on 2 nodes. Each node has 4 GB RAM. Each node has one instance of SQL Server 2000 ent. Recently we installed the /3GB switch and enabled AWE. We set max memory to 3.5 GB on each node. Memory on one node (actually the less utilized node) has achieved...more >>

I=B4m trying to install a MS Cluster with two IBM x370=20 machines and Storage Server IBM FAStT200 Fibre Channel. The cluster installation procedure complete succesfully. After the installation of MC we test the cluster=20 operations. After this test, we proceed to install MSDTC with the=20 co...more >>

I have a W2K3 cluster with the High Security Template installed. When I try to install SQL 2000 on the first node of the cluster, the setup fails while creating virtual server resources on the cluster. The installation works fine with the setup security template installed. The following ...more >>

I am planning on installing SP3 on SQL2000 with SP2. The SQL server is clustered and I am wondering if I am going to encounter any problems? I read the readme file and it looks as if it is stright forward, but I am worried becase it is a production database. I would appriciate any feed back...more >>

Is there any comparision whitepaper to describe to use a/a mode or a/p mode for SQL Cluster I was told that Microsoft suggested to use a/p mode, so during the failover to a/a mode server would have less chance to get trouble. Is this true? Any good reason to use A/A mode Both of my SQL cluster se...more >>