I've installed Windows Server 2003 EE SP1 Cluster successfully with two nodes and now I'm trying to install MS SQL server 2000 Cluster on it.. as part of the preparation is to add new resource for MSDTC before install SQL server 2000 then upgrade to sql server 2000 sp3a.. I've used two met...more >>

Environment: HP Servers and SAN Win2k3 EE (no SP1 but all WinUpdate patches) SQL2k EE w/SP3a I'm a newbie to this and some questions that I have are: SQL DB application will use DTC. Does DTC have to have it's own IP address, network name and disk resource? Is disk resource considered a...more >>

I've build a SQL 2000 SP3a cluster on top of an 8 node Windows 2003 cluster. We've decided to split the cluster up into 2 individual clusters and as such I'm attempting to remove some of the cluster nodes from the Virtual Server Definiton (as per the "Adding or Removing a Cluster Node from th...more >>

Hi everydoby, i'm new in this ng :=) I'm also new to cluster and i have little questions. I have 2 node (identical, HP DL380) and a san MSA1500, redundant path FC,2 network card for private and public.SQL 2000 clustered. These are my tests: 1. i try to unplug the cable (private connection, hbea...more >>

Hi, I am in the process of building a SQL Server "farm," but having to tone down the pace due to $$. I have just purchased a RAID1 (2 disc/10K rpm/146 GB) Channel 0, RAID5 (3 disc/10K rpm/146 GB) Channel 1 server with 2 CPU's. This summer, I plan to buy an identical machine. They will both...more >>

Cluster active-active. The installation in one server was lost and the S.O. was reinstalled. Now in one node there are two instances. How can I reinstall de second node and move the instance to it ? ...more >>

Hi, I have two physical SQL servers running under cluster. When execute a query that returns around 3000 records on one of the cluster node machine, it comes back in 3 seconds but if execute the query from other machine that to the virtual machine, it takes more than a minute. The other mac...more >>

Thanks a lot! You helped me, but now I have a few more questions: I am installing SQL Server 2000 cluster (1 instance) on Windows 2003 SP1 1. Do I really need WINS on the network? According to "SQL Server Failover Clustering" whiteparer I do. 2. What is the preferred order of installation...more >>

I have 2 2003 servers each running a separate copy of SQL. I have purchased a external storage Dell Powervault running RAID 5 to serve as the shared disk space. I would like to create a SQL cluster with these 2 machines. Each SQL server has databases that will need to be moved to the shared...more >>

Can one deploy a 2 node cluster with an instance on each node and the failover node be the other? Like node A & node B, A's instance fails to B and B's instance fails to A? -- Thanks, John...more >>

This is probably a hardware issue, but since HP is of no help, I thought I'd post here too. We have a SQL/Exchange 2-node cluster(Windows 2003, Exchange 2003, & SQL 2000) attached to a SAN(MSA1000). Drives are configured in RAID1+0, with a single array and 6 logical drives. Three week...more >>

Hi! I am planiing to install SQL 2000 EE on Win 2003 Cluster: 2 node cluster, Windows 2003 1 SQL Server instance (active/passive) In order to do so I need some answers: 1. Should I install Win 2003 SP1 on both nodes (what are the experiences?, any problems?). 2. What i...more >>

Hi all I am trying to work out if it is ok to install an antivirus product onto my Windows 2003 SQL Cluster. According to Symantec I can: http://service1.symantec.com/SUPPORT/ent-security.nsf/529c2f9adcf33a1088256e22005026f1/ea0f9eb688b1318c88256db700767032?OpenDocument&prod=Symantec%20AntiV...more >>

Hello: Does merge replication support clustering? I'm having some troubles about merge agent "querytimeout" parameter throught a clustered system, and the hints that are over there about "increasing timeout", "refreshing indices" and a lot more don't give any result. Anyone can help ...more >>

I do not have any experience with MS SQL. I'm a hardware engineer. I focus mainly on the servers hardware and connectivity. I was wondering, is it possible to cluster 2 (or more) nodes running all nodes on active / active as a single MS SQL database system? The servers are connecting to a ...more >>

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1 rows have many duplicates col2 has unique values col3 can have 5 possible values: 5, 10, 15, 20, 25 Variable @V can be equal to 5 or 10 or 15 o...more >>

Hi All, I built a SQL Cluster in a dev area next to my cube. Had two web servers pointing at it and everything was working perfectly. I picked up all 4 of my machines and moved them to my colo. This ment I had to change all the IP addresses associated with the machines, this all seemed to ...more >>

Hi all, I'm new to clustering. Is there any website on how i could learn to configure clustering. I have 2 new servers(Svr1 & Svr2) and san storage. On Svr1 i'm going to install Win 2003 and sql 2000. Svr2 is going to be application server(dfs, VB.NET, etc). Can anyone help me on how sho...more >>

Hello, does someone have information about the installation or operates a ORACLE data base on a Windows cluster? Regards Franz...more >>

Hello All, I need to move a SQL Server Cluster from one subnet to another subnet so I need to update 5 cluster IP addresses (node a, node b, cluster, SQL Server and MS DTC). Any help on how to do this would be appreciated. I found article 230356 explaining how to change the IP address in...more >>

We want to hear what you have to say! We would like to identify some Medium sized customers (4 - 99 total servers) *who are willing to talk to us* (the Cluster Product Team), who are running one or more of the following applications in a High Availability deployment using Microsoft Server ...more >>

Hi~ everyone. my two sql server were configured clustering service after that, in order to try to restore master database i changed from multi user mode to single user mode. but something happened. anybody couldn't access that database to enterprise manager and query analizer.(denied acces...more >>

Hello, Has anyone attempted in building a 2-node Active/Active Windows MSCS Cluster where node 1 is running Exchange 2003 and node 2 is running SQL2000? My proposed hardware will be 2 HP DL380 G4 Boxes Dual Xeon 3.6Ghz/2MB Processors 5GB RAM Dual MSA1000's Controllers Cluster F...more >>

after unplugging the public network of both nodes, waiting alittle bit and replugging them, there was a major problem in the cluster administrator - while openning its window the service seem to hang, the main frame of the program was blank ! is it an expected result ? what can be done to re...more >>

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? Detach and attach method don't work on this DB ...more >>

Hi GUYS, I am setting up a sql cluster on win 2003. i am using distributed transaction so using MSDTC. as far as i know WHILE Clustering MSDTC we have to give a unique ip address to the msdtc resource, is this ip address shold be same as cluster ip adrress or a seperate ip address. f...more >>

We have a 2 node active/passive SQL2K cluster running on Windows 2003 server. I would like to upgrade the cluster to SP3a for SQL2K, but my time frame for doing so is a bit limited. Is it possible to upgrade the passive node without affecting the active node or disturbing the production env...more >>

I have a F drive which located at a SCSI Disk Array, it's the default instance SQL's data drive, now I just switch the cluster from the SCSI array to SAN. Now, I want to switch the SQL data drive to a SAN drive. Question is that it's just simple to cut off the database, and detach all DB and co...more >>

I'm having trouble connecting to a named instance on a SQL 2000 EE cluster (Windows 2003). I have no problems connecting to the first virtual server by name or IP address, but I can only connect to the named instance by using the IP address and specifying a port (192.168.0.1, 1434). I can c...more >>

I'm looking for information about SQL2005's new featured called "Database Mirroring". What do you know about it? How does it compare to existing SQL2000 clustering/replication services? Will be only available to cluster servers? (I mean... shared devices, mscs, etc). Thanks ...more >>

Hi all I have a SQL Server cluster running active/passive. Over the weekend due to a network problem, both machines lost connectivity on the public network. We had our Failover Threshold set to 10, and period 6 (ie failover at most 10 times in 6 hours). Our cluster attempted to failover...more >>