Does anyone have a step by step for setup of a SQL 2000 A/A/P cluster on Windows 2003? I just want to make sure I get all the components installed in the correct order. thanks, Jason ...more >>

hi, have setup sql servers as a standalone. I need to configure a new server using clustering. Can someone point me to how to set up sql clustering on win2k please ? TIA MOE...more >>

I wanted to run my thoughts by the gurus here. I think I'm on the right track, but I just want to get some confirmation. This morning I tried to upgrade our NT4(SP5) SQL7(SP2) 2-node cluster. When I ran the Failover Cluster Wizard on the primary node and broke the cluster, it apparently did ...more >>

Hi Guys, We have been having issues with the SQL Server 70 cluster (Active/Passive) sp3 which was installed even before i joined my client. It keeps failing over every night automatically and its because of one of the resources called VSRVSVC.EXE (it says generic service on the cluster admi...more >>

Hi, I really would appreciate any help on this. Can a very large transaction log have a negative impact on write performance?? We were having a problem with VERY slow writes (30 seconds each) to a database. Reads were very fast (0 ms). The app is running on a Windows 2000/SQL 2000 A...more >>

andrew.collins@quest.com I have a Windows 2000 advanced 2 node cluster setup. I used VM Ware to build both nodes and I have virtual SCSI for the quorum and shared disk I successfully installed SQL to the cluster. However I did have to install to each node separately since a "race condi...more >>

Hi I want to implement Active/Passive clustering sql server, I am wondering if I can access to the idle server and run program (for instance, microsoft word, sql enterprise) by using terminal service Thank you very much. ...more >>

Can I have another Virtual SQL Server on the existing Cluster (MS SQL 2000 Cluster)?. Current configuration is SQL SERVER 2000 EE in an Active/Passive two-node Cluster Configuration. For example Cluster Name is CLUST1 and VIRTUAL SQL SERVER is VS1. My intention is to have one named instan...more >>

Hi All, I'm facing a problem reinstalling SQL2000 on windows 2003 cluster. As I'm trying to do migration, I did a test installation with a default name. Then, I wanted to change my instance for production purpose. For some reasons, I could not uninstall from the SQL installation CD, thus...more >>

Our quorum size in the MSCS folder is stuck at 32kb. The Reset quorum log at: is set to 4096 With it being at 32kb for sometime now is it best to stop the cluster service and Start up with the parameter -noquorumlogging Our failover is not allowing all of our home directory shares to ...more >>

We currently have an existing W2K Advance Server running SQL 2K EE and are planning on implementing a cluster using the existing server. Anyway to upgrade the existing database to a clustered install or do we need to uninstall and reinstall after the OS cluster is established? Looking fo...more >>

Hi I have SQL2K SP3 on W2k SP4 in an active passive cluster. Recently I have had problems with the cluster either failing over or attempting to and then hanging in an inaccessible state. The following errors appear in the W2K Application log... [sqsrvres] CheckQueryProcessorAlive: sqlexecdi...more >>

Hi I wanted to configure Failover cluster for SQL Server 2000 on Windows 2000 advanced servers I have only 2 no.s of windows 2000 advanced server m/cs. I dont have any shared disks and SCSI drives. Can I still configure the Failover clustering I would like to know more about the need for the s...more >>

Hi everyone, I have a Design Question about clustering SQL. I know clustering is = an expensive solution but I was given a project to provide high = availablity for Sharepoint Portal Server 2003. The environment = involves over 1400 users and I was given two HP BL20p servers to work = wi...more >>

We have a pair (active passive) of SQL 2003 running in a cluster. The problem is that the virtual SQL server only appears on one of the two networks we have running. The settings under SQL IP in the cluster manager only allows you to select one network. I want to be able to access the vi...more >>

Hi there Are any of you using merge replication to increase the availability of your sql server? I have a clustered sql server 2000 but I need to cover for the eventuality of loss of network connection to the datacenter or other event that would put the cluster offline. At first I set up log ...more >>

This is the error SQLSTP log file from the active node to the passive node which has already joined the cluster. The unattended install failed to kickoff or complete. I have seen another thread which was a terminal server issue. We do not have terminal services enabled. I am using the domain account...more >>