What scenarios would result in bringing the cluster down/offline ? I mean.. in situations when you apply OS service packs/security patches or SQL Server service packs.. To apply any of the above , is it as easy as fail over to other node i.e secondary while you apply all the patches on one and f...more >>

Do we need MSDTC for clustering ? Using SQL 2000 ...more >>

Whats the minimum no. of IP addresses I need to setup a SQL Server 2000 cluster and where do I need to use them ? Need to grab some from my n/w admins . Just testing the clusters ...more >>

Hi, I am trying to setup SQL 2000 Ent. on 2 node Windows 2003 Cluster in Active/Passive mode. The setup hangs at the point where it needs to display the disk selection dialog box. Below is an extract from the sqlstp.log file; ********************************************************** 14:49:2...more >>

Hello to all At this time I have problems in configuring a cluster in windows 2003 64 bits it has server itanium, with an external storage Eva3000 HP the problem that gives u the problems es fdisk error Reservation of cluster disk 'Quorum' has been lost. Please check your system and disk c...more >>

Tom, Affinity mask is also set to use all procs. Any other thoughts?...more >>

This is configured to use all processors. Do you have any other ideas what could be causing our problmes? Currently, we have hyperthreading turned off through the BIOS of our machine. Obviously, turning it back on won't hurt, but do you think it will solve our problem. Any help or idea...more >>

We have 2 IBM xSeries 360 servers with 4 processors and 8 GB of ram in each. These machines are setup in a clustered environment. Originally, these boxes had 2 procs in them and we added the additional processors 2 weeks ago. What we have noticed is that our execution plans are not usin...more >>

Hello, I have sucessfully setup a 2 node win2003 cluster w/ sql2000. I can move all sql resources to node 2 just fine when node 1 remains up and running. However whenever i shut down node 1 and all resources bounce over to node2 everything comes back online except: SQL server SQL serv...more >>

Hi guys: I would like to acquire a little hands on building a clustering environment. As per my initial readings, this is what I would need, could you guys let me know what I am missing or misinterpreting? Thanks HARDWARE 1) build two computers, preferable with similar hardware components...more >>

Hi I'm currently setting up a SQL Server 2000. My configuration is: Instance MyCompany running on ServerA Instance TheirCompany running on ServerB TheirCompany is mapped as linked server into instance MyCompany In my situation, the data in TheirCompany is only located on ServerB due to leg...more >>

Hi everyone, As of today, we are unable to connect to the SQL Server connection with Enterprise Manager. The operation fails with the following error message: A connection could not be established to DBCLUSTER01 Reason: Invalid object name 'master..spt_values'. Invalid object name 'maste...more >>

I am trying to move my pubs and northwind log files to a different shared disk on a clustered system (because I have data and logs separated). I am trying to do this via detach and attach db. I can detach the db just fine. However, When I try to copy the .ldf file to its new drive location I get...more >>

I have two servers, one server was set up with Windows 2000 Advanced Server that was clustered as a stand-alone and installed SQL Server 2000 Enterprise with a virtual name. I purchased another server and need to cluster this server with my first server. Both server have SQL Server 200...more >>

Hi al I have a scenary SO Windows 2003 Enterprise edition 64 bits, I built a cluster on two nodes ... than install SQl Server 64 bits i beginning to choose Virtual Server, choose the group SQL Server disk , put the name instance and finished when executing the setup of SQL Server CD again, to cr...more >>

Is it possible to use Windows 2003 clusters to have 2 active nodes, each with a completely independent virtual server/instance of SQL 2000 and have them both fail over to 1 single failover node? This would mean I would ahve node 1/instance 1, node 2/instance 2, node 3/failover, and node 1/instan...more >>

Can an Active/Active SQL Cluster, built on two 4-processor boxes, act as one SQL Server with 8 processors? ...more >>

Win2K SP4 with SQL2K SP4. Have noticed that some of our users home directories are not accessible when failed over to node A? Both from the user account and an Administrator with full permissions. Failing back to Node B they are accessible? I'm not seeing anything that jumps out to me ...more >>

Hi, Can you brief me/ point me to a document to set up a fail over using 2000 or 2003. We are looking for a fail over solution for our sql server but have no idea were to look. What would be the minimum hardware/software requirements? Any help is greatly appreciated. Thanks, David...more >>

Hi, i have installed w2003 and try to install sql 2000 server, but when appear the Remote Information screen i write the name and pass but the instalation broke.... just disapear the install screen and not happend nothing.... how can i install sql 2000 ?? thank's a lot Israel...more >>

Hi Guys, my sql server 2000 running in active/passive cluster mode. right now i have ony one raid array on which i placed datafile and logfile. now i am facing disk bottlenecks so i want to add one more raid (raid1) for log files. how ican do this . any special procedure? there will be much ...more >>

Hi guys, I must move my cluster SQL 2000 from EMC-SAN to another SAN. Is there a Tech doc that describe how I can do It ? (move quorum, move data\log) Thanks for any suggestion. Mirko...more >>

Would it be possible to create SQL 2000 instance on Windows 2003 Majority nodes set? I have two test seperate servers that need to be clustered without shared disks in multiple locations and be able to failover SQL services w/ rest of the resources under majority node set. Please let me know i...more >>

Hi. I posted the message below in microsoft.public.sqlserver.setup & microsoft.public.windows.server.setup and was advised to also post here. ----------------------------- I'm in the initial planning stage of a web site that is expected to grow to many users and a lot of data in SQL Server ...more >>

Hi All Is the SQL Post SP3a cumulative recently released by Microsoft Cluster aware? If not, does one apply it to the standby node first, then force the failover and then apply it to the primart node? Thanks J...more >>