Hello all, We are planning to upgrade the drives which are currently being used for clustered SQL, Exchange 2003, DHCP and File and Print Services. We pan to do the following: 1) Add the bigger drives 2) Copy all the data from the existing drives to the new drives 3) Change the new drive ...more >>

just a quick background SQl 2000 running as a cluster. We started a merge replication and had problems so i removed it. we had probelems with the database after I removed it so a programmer suggested I run a fixrep.sql script to remove traces of replication. After I ran the script the ins...more >>

What is the Best Practices way and quickest way to move a SQL Server 2000 Virtual Server database to a new server. This a production server with numerous users and the server can be down for only several hours. The server has Windows 2000 Advanced Server with SQL Server 2000 (Active/Activ...more >>

Hello Everyone, I am very new to the forum so I need to put my question based on SQL query. Is it the right place or if anyone can give me the link, I will proceed!!! Thanks ...more >>

Hi all, Does anybody know if the XPSMTP extended procedure (or any mail sending functionality for that matter) works (safely) in a clustered (active-active) SQL 2000 environment running on 64-bit Windows 2003? I decided to ask before trying, because the 64-bit environment is said to be ver...more >>

I have a very basic question regarding nodes in MSCS running sqlserver2k. I'm trying to understand what it means to load-balance. I thought load-balancing meant that if I have 3 nodes in the MSCS & all running sqlserver2k, the nodes point to single database on a shared storage. Basically, lo...more >>

I have documentation for Win2K which says run comclust.exe to add MSDTC . Running the same brings up the Admin window. Please point me to some documentation which clearly describes on how to setup MSDTC on win3K cluster Thanks ...more >>

Hi I am getting the error message listed below while starting my SQL Server on a cluster node, the server is up and running just the sql server is not starting this is the error message which i get from event viewer [sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818...more >>

I received the following error when installing the SQL Server 2000 on a WIndows 2003 Server : Setup failed to perform required operations on the cluster nodes. You may also receive one of the following error messages in the SQLSTP or the SQLCLST log files: Process Exit Code: (2) The system...more >>

Hi I need to move the transaction logs for all the sql db's (including master, model and user db's etc) to a seperate drive. Does anyone have any experience doing this in a sql cluster? Thanks -- Parky...more >>

Hi, I have two identical servers. I want to put Win 2003 Enterprise and SQL Server Enterprise on both of them. The data will be written to and read from the database. Is it possible to build a cluster with two independent sets of hard drives on each server (Server1 with his own hard drives in...more >>

I am looking for the Microsoft instruction to install SQL Server 2000 on Cluster with Windows 2003 Server operating system. I start the uninstall of SQL Server 2000 with the following error. "Another Virtual Server of the same name exists on the network" Please help me with instructions...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

We want to set up another office as an online disaster recovery site. Can I clister between two SQL servers over a T1?...more >>

I would like some advise on my plan to install an active/active sql cluster. The plan is to build 2 boxes with W2k3 server and SQL2003. I'll have 13 drives on a shared disk storage (two sets of mirrored drives) (two sets of Raid 5 [4 drives each]) (1 global hot spare). I'll create a 1 Gig l...more >>