Hi I am looking for a good guide on installing an SQL 2000 2 node cluster. Can any body recommend anything? Thanks ...more >>

? All of the sudden our server was totally sown. The communication to it was down down. The errors from the SQL Serve Log were: -- Process 0:0 (a2c) UMS Context 0x125669D0 appears to be non-yielding on Scheduler 0. -- Error: 17883, Severity: 1, State: 0 Any articles?, any reasons whay t...more >>

Becaurse of hardware warnings we had one of our "IBM x345 servers" (Model 8670-61X) updated with firmware and device driver . BIOS, ASM, RAID, ISMP and LSI mini port driver. After that we recive folloving popup on boot: "Service Control Manager : At least one service or driver failed d...more >>

I have a two node SQL Server 2000 cluster which I have upgraded to SP4. My application, running as a non-privileged user on another node, now gets an "access denied" error when it tries to check the state of the cluster using SQL-DMO. The code (in VBScript) looks like this: Dim oSQL s...more >>

Hi all, I'm trying to add a new node to our SQL Server 2000 SP4 cluster. Cluster node is Windows 2003 SP1. I can add the node to the SQL cluster, but when I try to add SP4 to the new node, I get an error message when I enter in the service password for the instance. Error message : Set...more >>

I'm relatively new to the world of sql clusters. We have and Active/Passive cluster with Windows 2003 server. I recently did a test where I manually moved the resources from node 1 to node 2. I've noticed that the MSSQLSERVER service was now running on the 2nd node, but not on the first. ...more >>

Hi, Our 2 node(active/active) cluster is running on an old machine and running SQL2000 and W2k. We wanted to upgrade the hardware and the OS to W2003. I am planning to setup the new hardwares with W2003 and SQL2000 and then moved the resources over to the new servers and then get rid of the...more >>

I have a SQL Server 2000 cluster with Windows 2003 server. Periodically I run a job that deletes all of the files out of the P:\dallas_mrkt directory on the active node. This is active/passive cluster with two nodes. I would like to modify the job listed below so that it will test to se...more >>

I have a 2 node windows cluster, and few days ago 1 node died, after install again the node that failed, when i want to install the SP4 of SQL I can´t beacuse "not all operations could be reached in all nodes". I have this errors on the new node that i have installed. SETUP.LOG [InstallSh...more >>

I have a Cluster Server with Windows 2003 Server and SQL Server 2000 as the database server. Periodically I receive in the event viewer from the ClusSvc that the time delta between Node A and Node B is X (in 100 nanoseconds). What is consider to be good and bad ranges of values for the time...more >>

Hi, I have SQL2000 installed on a cluster. The service is starting, but the cluster fails to detect it started. in event log i get: 1:[sqsrvres] ODBC sqldriverconnect failed 2:[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][...more >>

Hi, In windows 2003 server you have NLB (Network Load Balancing). Can i use this to load balance my traffic to our sql server? I know you also have "Microsoft Cluster Service" but that's only available with Windows Server 2003 Enterprise Edition. So is it possible to load balance my traf...more >>

Hello : ) This Thursday 21st, I have a second interview for a DBA position. I have been looking for an opportunity like this for awhile now and I hope I don't blow it. My question is regarding replication/synching for SQL Servers at different locations. One of the first tasks (if I am hi...more >>

Hi All We are trying to consolidate all the SQL servers (more then 250 instances). We are considering Multi instance Sql Cluster on SAN Is there a document/weblink that expalins the SAN systems , and Installation/Setup of SQL Cluster on SAN. Pro's and Con's thanks in advance ...more >>

I am attempting to montior failovers, using Sitescope, so does anyone know event what events are created when a node fails over? -- Dave B...more >>

I currently have two clustered servers. OS - Windows 2003 (SP1), SQL 2000. These servers are getting old so what I wanted to do is add two new servers to the cluster and take the original two offline. I have loaded the new servers, connected them to our sans, and added them to the cluster. I a...more >>

About 5 months ago, I posted a query to this group after experiencing failures with my database maintenance plans (during the verify phase) that run on SQL Clusters on Windows 2003 (http://groups-beta.google.com/group/microsoft.public.sqlserver.clustering/msg/6a3dce3dc176c29b?dmode=source) I ...more >>

Dear all, I would like to build an Active-Active model with two nodes (Win200 AdServer) question is easy: which are the most important parameters as well as little things that then are so important when everything is running in production? Same memory for both? Same processor type for bot...more >>

I have a clustered enviroment made of 2 win2k advanced servers clustered in a network. Servers are running sql 2000 that hosts a third party database X. Now X was working perfectly until these servers were clustered. Users accessed X via a citrix client. Any idea as to why accessing this third p...more >>

Hi, After serious storage problems, I need to uninstall a cluster sql 2000 64 bit over a two windows 2003 servers 64 bit Itanium Dell PowerEdge 7250, attached a storage HP XP 1024, and after reconfigure the SQL Server failover cluster. I known, it's a big task, do you have some guide or p...more >>

Hello. After I installed new 4 new disks in the SAN and added them as resources in clusteradministrator im not able to see them when I try to expand the filegroup. I can see the disk in "My Computer", but not in the SQLServer, is there something extra there should be done to enable the new ...more >>

Hi We have a SQL server 2000 cluster, built on Windows 2000 Advanced server. We are using an Active / Passive configuration which has 4 instances of SQL Enterprise, and 1 Instance of IIS. Both boxes are identical, and clustering works just fine. However, in order to use the 4Gb in each box...more >>

Hello, I already feel as if I know the answer to this question but I want to confirm my thoughts before moving forward. We have a clustered default SQL instance running W2K3 Enterprise and SQL2000. We were having a problem last week that we could not solve via SQL. We decided to force a ...more >>

Hi, I have a bit of code which I need to take the last character of a field and place it at the end of the output. (Sorry if the English does not make much sense – let me explain further) The first bit of code is fine: SELECT U_hvdfinal.* INTO U_T_STEP03F FROM U_hvdfinal WHERE ...more >>

Hi, we have 2 node Active/pasive cluster system, and thinking to convert it to active/active. In order to determine all pros/Cons I'm trying to find out all comparison issues. Any article,comment on this, will be appreciated. Thanks Banu...more >>

i have a microsoft sql 2000 server sp2 (on purpose because of erp, jde edwards) set up on a windows 2000 server cluster (advanced server - 2 nodes), with 4 gb of ram i have already included the /3gb switch in the boot.ini file. 'awe enabled' value is set to 0. when testing memory utilizati...more >>

Hy, I have this problem, when I try from the setup wizard of sql 2000 to add the new node-c the node is listed unavailable. I add the node-c to the cluster group and function without problem with node-a and node-b, the sql 2000 in node-a and node-b is function without problem, I not underst...more >>

The KB article, 899761, is silent regarding applying this hotfix to a two-node cluster. Please guide me in how this should be accomplished or provide me with a reference on this subject. Thank you. jdhawk ...more >>

Hi, We will build new clustering SQL Server. The question is that what kind drives configuration for user-defined database data files and transaction log files will improve performance, RAID 1+0, RAID 0+1, RAID 5 or RAID 10 etc. Regards! -Chen ...more >>

Hi, I have a two node failover cluster with two external disk arrays. I have these two array for some special testing. I no longer need both of them and need to do some specific testing with just one array. My problem is that the array I need to test with has all my SQL data but the other a...more >>

Hello, I have the problem that in some cases it is not possible to delete a file on a shared folder in a Windows 2003 clustered environment. Message: 'Access Denied' and the properties for the file are unavailable. Looking on the clustered servers in Share Sessions, the file is not open. ...more >>

hello, I am going to install SQL Server 2000 on Windows2003 server with (Active/Passive) configuration I have db space as 600 gig , ranges 1 gb to 90 gb. i have one concern about how log failover to passive server will take in case of it need? whether it depend on the db size or file group ...more >>

We have an active/passive cluster running SQL Server which is the back-end to an ASP based application. The servers in the back-end cluster have 6GB RAM. Without using PAE and AWE or 4GT the OS is currently using 3.5GB (SQL Server is using 1.7GB). We want to be able to use the full 6GB of ...more >>

I've built a single-instance Win2k3sp1 based cluster and installed SQL2ksp3 on it. The servers are symmetrical and have 8GB RAM ea. Currently, I plan to enable /3GB switche in boot.ini, and will also enable /PAE and AWE. I left the pagefile (about 11GB in size) on the c:\ drive where the OS...more >>

I understand from Microsoft that a SQL Server 2000 Cluster on Windows 2003 Enterprise can be run with a non-administrative service account but I have not been able to get this to work- the SQL installation fails with "This operation returned because the timeout period expired" and, while sqlstp....more >>

Hi Can anyone tell me how to find the location fo the Quorum disk, which is not located in the server but in any one of the nodes? I have checked the registry of the cluster server, it tells me the path of the quorum disk but not the node name or the machine ID. I assume it has to do somethig...more >>

We are in the process of bringin up our new cluster and have run into an odd issue regarding the IP address that SQL Server is listening on. We currently only have a single node but we will be addin a second in the next couple of weeks. The cluster has an IP of xx.xx.xx.8 The first box ha...more >>