When I try to add a node to SQL Server cluster the installation progarm exits without any messages. I think this problem was described in KB273769. I requested hotfix for this problem from Russian PSS but they told me (referring to european PSS centre) that hotfix in no longer available and i...more >>

Unfortunately several of my sql users need tot run cmdexe jobs (dts-packages). To keep them from totally destroying my server I configured a proxy account with not to much rights on the files system. For each virtual server I created a separate temp dir for the proxy user. when a cmdexec job i...more >>

I have 2 nodes of SQL 2000 Enterprise edition running on 2 windows 2003 (without terminal server) When i tried to test the failover by selecting move group from cluster Admin. Every resources succesfully failed over to the other server except SQLServerAgent, it was shown online pending for a ...more >>

Hi all, Are there any consequences if Cluster IP resource is running on Node A and SQL Server resource is on Node B? Thanks...more >>

Could someone point me to some documentation on the best way to remove a node from a SQL cluster. It's a two node, two instance cluster, and I plan to rebuild one node, fail to the rebuilt one, then rebuild the remaining node. -Karl ...more >>

Hi all My SQL Cluster, has a database with 13Gb, but the transaction log is huge. I already stopped the file from gowing more then it it's but is there a way of reduce this file?)already try to shrink the file without sucess). Can i for instance, detach the database an start it with a new l...more >>

hi all got a situation here, there are 3 app server that are running a same application to delete records in the sql server periodically. what happen is that they all start up at the same time to delete records on the same table.(this could be fixed by varying the start up time on each app s...more >>

What causes SQL Server to fail from the active node other than the heartbeat flat-lining? I have the cluster installed and tested the heartbeat by unplugging the active machine. Failover works great. My question is what else can cause the failover? Lets say we have a memory leak. Is t...more >>

Dear all Firstly, please note that this is PURELY a Clustering / Active Directory question and nothing to do with SQL Server ... there just wasn't any other clustering newsgroups around!! Anyway, we have as Server2003 Cluster and i'm trying to setup a group that has a Network Name Resour...more >>

We have a SQL 2k Single Node Cluster that we are adding a Passive node to. We have installed everything but are having issues installing SP3a on the Passive node. The Active Node has SP3a already installed. We get an error stating "All cluster disks available to this virtual server are owned by ...more >>

On an active/active cluster what is the proper way of changing the port # on the named instance after an install is complete and in use. ...more >>

I am a newbie to clustering so I hope this makes sense. Does the Cluster Manager have to be in the sysadmin role? If not, what are the roles that it does require? Thanks for any guidance. Neil ...more >>

According to the documentation the chosen Cluster name and IP address need to be unused before installing the cluster. The IP address is not a problem, but it will be a difficult task with the Cluster Name as the business processes have many scripts, DTS packages, stored procedures and views that...more >>

Hi all, We are afraid to start to hit the limit of the capacity on our production server and we are starting to think about scalability. We would like to scale out SQL Server and I wonder if it is possible to load balance SQL server. Is there any third paty software able to do that? It seem...more >>

In SQL 2000 Clustering, can I have only one default instance for the entire cluster or can I have one default per virtual server. In other words, can all my SQL installs in a cluster be default, each on a different virtual server? ...more >>

1. In MSCS and SQL Server 2-node clustering on windows 2000 advance server, are there any restrictions on the hardware. That is, do the 2 nodes necessarily should have the same number of CPU and memory? 2. when we have 2 node with sql server in cluster, can we install another non-clustered ...more >>

Hi, SQL 2K EE is running on a 2-node cluster. All was fine. Suddenly, node 2 owned the cluster group and now SQL is running on node 2. The reason is the problem: One node 1, SQL service is not starting and the MMC SQL snap-in returns "Cannot generate SSPI context" error when trying to conne...more >>

Hi , If I create a database , it will have a *.mdx and *.log files cater for that database. If I create a index (clustered or non clustered) is it store on the mdx files as well or index pages are store on different files ? -- Travis Tan...more >>

Hi. We need to load data using bulk utility, and We wolud like to use Remote Administration to do this. Then I would like to know if there are some problem to load data using bluk and remote administration. We have Windows 2003 Enterprise Edition and Active/Pasice schema. Than you for you...more >>

Hi all, I am planning to put one instance of SQL Server 2000 sp3 on a two node Windows 2003 EE MSCS. Each node has two channels, with each channel running RAID 1. The page file is in one channel, and the OS in the other. Each node has 4GB of RAM, and PAE enabled. The pagefiles are locked ...more >>

Can SQL 2000 Standard edition be installed on Windows 2003 Cluster Server? Thanks Ayad ...more >>

Hi. Someone has a step by step guide to install and configure the w2003 EE cluster and to use SQL2k failover cluster active /passive solution? Thank you...more >>

Got a pair of HP DL380s clustered and am getting ready to install SP1. Anyone have problems with the SP in a SQL cluster? Put SP1 on a Dell 1750 print cluster and it erased the RAID drivers on one of the nodes - something I definitely want to avoid on my SQL box. Thanks....more >>

Hi. I need to install 2 windows 2003 servers on cluster and after configure the SQL Server failover cluster. Do you have some guide to do this? Because I have been material about windows 2000 and sql server, but not about windows 2003 with sql server. Thank you very much...more >>

Hi guys, I have an existing sql 2k enterprise server and we're going to configure it for server clustering. We have custom made DTC package and most of the application use it very often. My concern is how do we migrate this custom made DTC package to the new environment(sql cluster)? App...more >>

Hi, I'm trying to create an index on a newly created table. I want the index to be on the field ref. I tried running: CREATE INDEX ref ON U_segment (ref) but it's just sitting there! The ref is unique anyway, and there are about 700,000 records. Any help, or advice would be apprea...more >>

Can anyone tell me if it's possible to rename a cluster? Fro example, we have an Active/Passive cluster made up of two servers. 'Server1' and 'Server2' which make up the cluster 'Cluster1' is it possible to rename this to 'Cluster2' without affecting the servers that make it up? Thanks ...more >>

Currently migrating a SQL application from an old Win2k cluster to some new hardware. The new hardware will run as a Win2K3SP1 cluster. The App people would like to keep the names the same for all servers and virtual services so that clients are not affected. Downtime is not an option....more >>

Two nodes of cluster are running. When I run setup SQL after 2 seconds setup disappears and nothing is doing. I don't have first setup screen so I can't choose "Virtual server" to install SQL na Cluster. But when only one node of cluster is running setup is starting but during setup I can't c...more >>

Is it possible to have 4 SQL instances in Cluster on 2 windows server. Active/passive set-up. In detail, what i mean is: I have 2 windows OS - WinClustA with WinClustB On WinClustA - SQLInstA (active) and SQLInstY (passive) On WinClustB - SQLInstB (passive) and SQLInstX (active) In case o...more >>

I am new to SQL server so any guidance is much appreciated. We have two logical drives for our SQL server.We are upgrading from a smaller driver to a bigger one. We have copied everything from one drive to the other after doing so we decided the easiest thing to do would be to change the d...more >>

Hi, I seem to understand the terminology of failover clustering as well as the sibgle/mulple instance installations but it seems it does take about 2min for a node to take over etc. I also red about log shipping and transactional replication... Is there a way to load balance that can be don...more >>

I'm working on a performance problem on a SQL server 2000 W2K SP4 Active / Active cluster. The primary database (bigdb) is 140 Gb and has 1200 users. Looking at perfmon I am suspecting an I/O bottleneck. The 8 CPUs in the system run all under 50%, and the 4 Gb RAM shows only 3.2 Gb in use. ...more >>

Dear, I am needing to grant tolerance to shortcomings to a Server SQL. The consultation is the following one, in Windows 2003 can have up to 8 nodes in a Cluster, in my Cluster at the moment have two instances of SQL, it is to say, an active/active, according to the above-mentioned, I can add h...more >>

Hi all - I'm curious if any of you are running Dell's rebranded EMC CX line of storage enclosures and if so, what your experiences with them have been. Also, any experiences with their Fibre Channel offerings would be greatly appreciated. Thanks. -MB ...more >>

I am running a default instance on my Active\Passive cluster and want to install a named instance on the same cluster. How is that done? ...more >>

Hi I have a 2 node windows 2000 Cluster with a problem. I think the quorum log became corrupted and now on both nodes the cluster service cannot start. Without the cluster service running i cannot access any of the resources. On the event viewer i have some error messages indicating that th...more >>

Hi all, Need u guys help again. I have 2 nodes running sql in the company. My question is there any way that i could create a script such that the primary node will failover to the secondary node at a certain day and time that i specified in the scripts so that i can do maintenance on the prim...more >>

Does anyone know where Microsoft put the following article? 812666 How to recover a failed full-text search resource on a clustered instance of SQL Server 2000 Thanks, NMC ...more >>

Later this summer, I will need to establish a 3 node cluster using Windows 2003 and SQL Server 2K using Veritas Cluster Server software. I don't have any experience setting up a 3 node cluster, only a 2 node cluster using MSCS. What are the primary differences between a 2 node MSCS cluster ...more >>

Hello, I have a problem that perhaps someone could share some suggestions on how to resolve it. We have a SQL Cluster with a primary and secondary node. We also have a File/Print Cluster with a primary and secondary node. Both clusters are in the same rack with two UPS’s. The server ro...more >>

The cluster consists of two nodes and of two instances. One default sql instance and one another named instanse. To connect to the named instance all the clients have alias(done by cliconfg.exe), but when the instance fails over to another node no one can't connect to this named instance any...more >>

Hi all, thank in advance for your help. The company I work for have been predominately using Oracle and IBM DB2. We do use Sql Server on case by case basis, but there is no well implemented infrastructure that will help us leverage MS Sql server. There has been initiative between us (deve...more >>

Hi all, I am trying to weigh the pros and cons vs implementing a sql active/passive cluster & using log shipping as a failover strategy. I have successfully setup a custom log shipping infrastructure using sql standard edition and windows server 2003 standard edition for a client and it is r...more >>

Hello I have a question that I hope someone can shed some light on. We are currently running a dedicated Dell 2850 SQL server box with a single database on it that has become very heavily used over the last year. What we'd like to do is to add another server (rather than buying higher spec ...more >>

We have a cluster with production server installed on one node and analytical server installed on the second one. We encountered problems during execution jobs on production server - jobs retrieving data from linked server (analytical server installed on the second cluster node). From time ...more >>