Okay go ahead and shred me now, and then please see if you can answer my question. I have a client that is living in the dark ages. Currently they are clustered on NT4.0 and SQL 7.0 using legato. We are moving them a step at a time to SQL 2000/Windows 2003 clustering. W2k and SQL7.0 using mi...more >>

Hi, In out production clustering server, installed SQL Server 2000 and sp3 applied. Around 2:00 a.m. this morning, during the database loading, the SQL auto stopped by self. The errorlog shows spid3 SQL Server is terminating due to 'stop' request from Service Control Manager. I checked spid...more >>

Hello All, I have a SQL Server 2000/Windows 2003 2-node Cluster single-instance (active-passive) and it is working perfectly. I also implemented log shipping from this cluster to a third computer. And also works perfect. But I have seen that the shared folders in the cluster, required for...more >>

Hello! Month ago we installed the did cluster for Microsoft server. It is 3 machines under Windows Server 2003 Enterprise. 1 and 2 are cluster with MS SQL Server 2000 + SP3 3 is the storage under WinTarget 1.2 for database only. web server is on the machine #4 under Windows 20...more >>

Hi, I already have one virtual SQL server in the cluster, it's owned by only one node. Now I added another node into the cluster, and we don't want this node to be a passive node, and don't want go to multi-instance . So, the question is if I can create another one virtual SQL server on the...more >>

Hi all I have Sql Server 2k configured in active/passive Cluster on Win2k3. Now because the passive is just ideal and sitting there doing nothing, i want to use it to host One instance of the Sql Server, 1> Can i do that, i mean Node1 hosting SqlSrv1 and Node2(passive for SqlSrv1) hosting SqlSr...more >>

I have an active-active cluster env. The servers were migrated to new servers, but the storage is the same. The serves were installed and the storage re-connected. The db structure was not changed. The cluster and SQL services have the same domain user. The problem is the full text only works...more >>

We've been struggling with a problem for a while now. If anyone has has a similiar issue, I'd appreciate it if you could share it here as it may lead me to a solution... The Cluster houses SQL and IIS (bad I know, but it shouldn't cause the problems we see) We have the following Cluster h...more >>

All, I am in the process of upgrading windows 2003 ent with SQL2000 ENT stand alone server to a clustered environment. The servers that I am using are identical, and will be using shared storage via EMC Clariion. I have setup clusters for fresh/new installs, but I have never upgraded/rein...more >>

what's the meaning of taking the sql-server resource offline ? what is happning behind the scenes ? is it the virtual server offline ? is it the specific node service offline ? why is it that when i move the group (with these services offline)the cluster admin doesnt restart them ? why bringin...more >>

My question is : What would happen to the jobs which are running,while failover occurs? I have a Active \ Passive SQL Server 2000 EE SP3a with Hotfix MS03-031 on Windows 2003 Enterprise Edition. When I testesd the Fail over from the Primary node (Node1) to Secondary Node (Node2) there was...more >>

Hi, I have a Windows Server 2003 Cluster with two nodes. I needed restart the second node for maintenance, after that the Cluster Service on second node stop ... The first node it's ok. I tried "Evict Node" and join again, but when the setup try to start cluster service I receive the follo...more >>

We have SQL Server cluster setted and running, yesterday, we moved servers to another location, and assigned cluster servers to new IP address, now our SQL Server can't start. Does anyone have any suggestion what I should look to fix that issue Thanks Yong ...more >>

Hi, When I installed a SQL 2000 Cluster Active/Active I defined one default instance as SERVER01 and the other instance as SERVER02/I2. Is it possible to use the second instance without put "/I2" at the end of name server? Do I must to install two named instances instead one default inst...more >>

We would like to restrict the number of records returned in a LEFT JOIN query but we find that it doesn't work as it supposed to be. Query: select t1.statdescr from table1 as t1 with (nolock) left join table2 as t2 on t1.tpklrpap = t2.tfklrpap and t1.statdescr not like 'CANCEL%' How...more >>

Currently have a 2 node windows 2000 cluster, active/passive, with sql 2000 running a data vault that's controlled by node a. Would like to upgrade to windows 2003, but run active/active with sql running on node b. To do this, do I have to reinstall sql server? I'm at a loss and all help an...more >>

Hi, I finished the installation of the SQL 2000 Server with one default instance on a new cluster. After that my boss asked for a new name to Default Instance ! Ohh my God ! Can I change the name of Defaul Instance ? thanks, Rubens I ...more >>

SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes. We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT services use. When I change the password for this account in active directory, I also changed the password for the services in the Services properties...more >>

All, I was looking for a database centric developer conference. Any suggestions please ? Thanks in advance. Bill ...more >>

I have recently had to rebuild my SQL Server 2000 sp3a 2 node active/passive cluster running on Windows 2000 AS SP4. We ran into issues about two weeks ago after a SAN migration (I'll spare all the gory details). When my previous cluster died, I used one of the nodes as a stand alone instanc...more >>

Hello, I am new to distributed databases. I wanted to use stored procedures in distributed databases. If a view contains query in which tables from different servers are used, how should I reference them. For example Suppose me view is CREATE VIEW dbo.Example1 AS SELECT...more >>

I have a setup of SQL Server 2000 Active \ Passive Cluster on Windows 2003 Environment. Maintenance plans were created when the Node-1 was active. Two weeks back the SQL Server cluster service failed over to Node-2, where in all other services are remain in the Node-1. But the backup jobs ...more >>

Hi, I a a two node win 2003 cluster running active / active with serveral SQL 2000 virtual servers between them. I have noticed the following and am wondering if this is correct behaviour and if not how I correct it: 1) If I start up enterprise manager and go to register one of the Virtu...more >>

Anyone here with hands on experience with SQL Clustering and using IPSEC? Perhaps we could exchange information... -Arnie Rowland ...more >>

Hi all, I have a SQL Server cluster running which one database server machine is active and one database server machine is standby. But once I tried to test the failover, I have found that both database server will claim it as active. Which the case is one database server will operate a...more >>

I need to change the SQL server license mode on an installed SQL server 2000 cluster from processor license to per seat. Does anyonw know? ...more >>

I would like to know the group's experiences on that topic. I had several issues in the past but antiviruses had changed a lot and maybe you have good/bad experiences to share that I can apply to a clustered SQL2000sp3/w2003 install i'm doing now. Hopefully you can include AV brand and versi...more >>

We're in the process of designing a 2 node sql cluster for a client. I want to know the best way to backup/restore the cluster using Veritas Backup Exec 9.1 or 10.0. I've installed the remote agent to the cluster with no problem. I'm using a dedicated management pc that is not a node in the...more >>

I'm looknig to set up a miniature clustering lab at home and looking for some advice. I would like to hopefully keep the price tag to around $750-$1250. I've already found a couple of boxes that I'm going to use for my nodes (dual node cluster). I can do all the internal stuff myself (NI...more >>

I have a data warehouse transactional replication environment in which we have muliple Publisher/Distributors(100+) and a single subscriber. All Publishers and subscribers are SQL 2000. We recently converted the subscriber box to a Win2003 Cluster.(Publishers are Win2K for the most part, there...more >>

Is there a way to break my Active/Active cluster back to have a single stand-alone SQL server? internal politics and a rogue admin who applies security patches willie nillie to the cluster nodes is causing more downtime than the cluster is worth! Hopefully there is a way that this can be...more >>

Hi, I've 3 PC. 2 x Win2K AS and 1 Win2K Pro. Is it possible to cluster the 2 Win2K AS as Primary & Secondary while the Win2K Pro serves as the shared disk server ? Do I need to get a Raid card for Win2K Pro PC ? Advice pls....more >>

Can the Named Pipes protocol be removed from a SQL Cluster (SQL2000/Win2003)? And it still function properly, of course... -Arnie Rowland ...more >>

This is a quick one: does the domain account that is installing SQL Server on a cluster need to also be a domain administrator? If it weren't, would that cause the SQL insatall to fail? Thanks again! ...more >>

I've read about a thousand different things and really need a straight answer: I'm setting up clustering on a dual-node W2K3 cluster. If the applications that are accessing the SQL Server DO NOT utilize MSDTC, do I need to even bother with creating the group, resources, etc. for MSDTC? I...more >>

I am attempting to install my 3rd cluster into an ip5000 iscsi SAN and I am encountering some very odd behaviour. I have finally concluded after about 25 hours of testing that there is an issue with the SQL2k install handling disk volumes of, in this instance, 160GB. I initially thought this to ...more >>

Hi All, I hope this is not a FAQ. I have a 2-node Windows Server 2003 cluster, with SQL Server 2000 SP3a. This is a development system, and is actually implemented using VMware (though I don't think that is relevant). Occasionally when moving the SQL Server group, I get random failures o...more >>

Can you Implement Log Shipping between geographically dispersed clusters. The main aim is to provide DR for 2 clusters to a single cluster located in a seperate Datacenter. Any input will be appreciated....more >>

Hi there guys I am having a problem with a clustered default instance. During the process of changing the statup parameters with the intention of moving the Master to a new LUN. The SQL service failed for an unrelated reason, however the startup parameters at that stage were deleted (Blank, ...more >>

Hi, I am getting the above error on the production box which has SQL 2000, sp3a build 8.00.780 with AWE and PAE enabled and SQL Server (Active/Passive Cluster) has been allocated 7GB out of the total 8GB on the box.SQL Server froze for almost 10 minutes and it came back fine after that.But thi...more >>

Does any one have experiences with Mixed mode cluster? I am trying to add a windows 2003 node as primary node to an existing window 2000 active passive cluster. Here is what i did: From WINDOWS 2000 Active/Passive SQL 2000 cluster, Evicted the PRimary node. Loaded WINDOWS 2003 onto the pri...more >>

I am configuring a two node SQL cluster and i have 5 physical disk arrays and i intend to use them in the following order disk array 1 for quorum disk array 2 for DATA disk array 3 for backup disk array 4 for TempDB disk array 5 create two partition (1 for Tlog and 2 for MDTC disk resorces...more >>

There on and accessable through Explorer and Disk Management. However when I try to install SQL as a new virtual instance I only have access to my Quorum Resources. Installing Sql2000 on 2003 server Active /Passive. One instance is already installed and running. Has been for several months...more >>

Hi Everyone, I have an Active/Avtive 2 node cluster running WIN 2003 with SQL Server 2000 (SP3a). Over the last couple of days i have been experimenting with it and have noticed the following behaviour and was wondering whether it was normal. When all resourses are running on NODE2 (incl...more >>

Hi, Can I put the MSDTC resource in Defaul Cluster Group ? I dont have available disk to it. thanks, Rubens ...more >>

Can anybody tell me the differences, advantages or disadvantages in installing an active/active cluster as VIRTUAL/INSTANCE1 and VIRTUAL/INSTANCE2 against VIRTUAL1 and VIRTUAL2 We did not seem to get the option to install a second instance on the first virtual server and so opted...more >>

I'm looking for help in locating a script that would allow deliberately causing a cluster to failover. (For demonstration and testing purposes.) And ideas or suggestions would be appreciated. Thanks, Arnie Rowland ...more >>

Hi Guys, rirht now my databases running on two seperate sql servers server1 and server2 and ecah having MSDTC . Now i am planning to shift these two servers into a cluster. 1)shall i go for active/passive or active/active. 2)if active/active then it will be named virtual instance will it r...more >>