What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster? Cluster is already setup and virtual sql instance running ok... Thanks ...more >>

Hello, I have a sql 2000 box that has roughly 15 datbases. How do i determine how much memory/cpu a particular db is using? thanks! Calvin ...more >>

2 out of 4 instances on my 3 node cluster wil not come online on one off the clusternodes, unless I add an alias (which I removed after installing sp3). The application eventlog complains about not being able to connect to the instance. I can connect to the instance remotely, but apparently ...more >>

I receive a "Cannot generate SSPI context" error message when you try to connect to a SQL Server 2000 SP3 server computer. According microsoft's article ID 843248 there is a hot fix. I do not want to install SP2 just the hot fix. Does anybody know the actual ID name of the hotfix. I am tr...more >>

What is the better to use in active/active SQL 2000 cluster ? 1 Default instance and 1 named instance or 2 Named Instances ? There are any advantages or disadvantages ? thanks a lot ! Rubens ...more >>

To keep the number of driveletters to a minimum, have the same directory structure on the instances and do something with disks and performance I tried this: MSSQL$I1\Data \Data1 <- mount point \Tlog \Backup \Backup1 <- mount point MSSQL$I2\Data \D...more >>

Hi All I want to call DTS Package from Job. How, can I do that ? First DTS Package transfers data and then it calculates on that imported data. Wating for reply Silent Ocean ...more >>

Does anyone know how to enumerate cluster info (Microsoft cluster server 2000) through VBS. But more specifically, is there a way to execute the MOVE GROUP function from within VBS/VBScript. Thanks, JFR ...more >>

Hello, may be a dumb question, but how do i determine if i've setup msdtc correctly on a sql 2000 cluster? thank you Calvin ...more >>

I am trying to install a named instance on an active/passive cluster using sql 2000 and windows 2003 both entrprised editions. HEre is the latest sqlstp.log which says it failed/. 01:45:22 Begin Setup 01:45:22 8.00.194 01:45:22 Mode = Normal 01:45:22 ModeType = NORMAL 01:45:22 GetDefinition...more >>

I have a SQL Server 2000 Cluster with Windows 2000 Server. The Cluster was set up as a Active\Active and I would like to change it to Active\Passive. What do I need to change go from Active\Active to Active\Passive? Thanks,...more >>

we have an active-active sql cluster configured as follow: server A - 4gb ram - sql server instance #1 server B - 4gb ram - sql server instance #2 currently each sql instance is configured to use at most 2gb of ram. in case of failover, both instances switch on one server, effectively usinge ...more >>

Hello: I have installed SQL 2000 Enterprise in a Microsoft Cluster Windows 2000 several times. I am trying now to install it on a MSCS Windows 2003 and I can see there are several differences. First of all, when I did with Windows 2000 the first step was to configure the Microsoft Distribu...more >>

I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you....more >>

Hello, I'm trying to set up alerts for jobs and backups, using sql mail. Will this work in a clustered enviroment? if so, can you please forward some information on how to get this set up? thanks in advace. Calvin ...more >>

Hi , is there any command to display current cluster name through query . Thanks ARR ...more >>

I have a 2 node cluster running Win2000 enterprise and MS clustering. Also SQL server. Would there be a problem using the same domain password for SQL and for the clustering service? I thought I read that there may be a problem but I don't recall where it read it. Thanks for any help. ...more >>

Hi I have 2 questions, but related! We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2 node cluster. Each node currently has 2 NICs installed, one NIC for the local heartbeat and the other for the LAN connection. We now need to add another NIC to each cluster nod...more >>

OK please forgive me. I dont normally cross post, or ask the same question twice, but Im in quite a pickle here. Ive been using replication in a non clustered environment for years now. Ive never seen extreme slowness with the initial snapshot of replication like Im seeing currently. And to to...more >>

I have multiple (2) instances of sql 2000 running on my windows 2003 cluster. I have the default instance owned by server1 and a named instance owner by server 2. If I shutdown server 1 then my default instance fails over to server2. Now server two is running both. (no problem). If I shutd...more >>

Hi, How many instances of SQL server I need to install in 2 - node server cluster for Active/Active and for Active/Passive mode 'on each node' ? Pankaj...more >>

Hi, 1. What is the use of Multiple-Instances of Sql server? 2. If I have only 1 Database, which Mode can I use (Active/Active or Active/Passive) and why? 3. What is the difference between Active/Active and Active/Passive modes other than the fact that only Active mode holds the shared d...more >>

Dear all, We need to move SQL 2000 Cluster on Win 2003 server box from test to prod domain. What are the steps we need to follow to make sure SQL 2000 cluster is up and running in the new domain. I know that we need to change the service account from window services. Can we change the IP add...more >>

Hi I have 2 SQL servers (Active/Active) with a SAN. I see to get a very long connection delay when connection to the second instance from a webserver this can be upto 3 seconds. Each Instance is active on the opersite server and the second instance is running on port 1434. Does anyon...more >>

Hi, I completely understand that SQL-Clustering is failover technology and not a load balancing technology. 1. What I'm wondering is when you go for Active/Active mode, then whether both the nodes communicates with the single instance of shared device or only 1 node communicates with it?...more >>

Hi, I completely understand that SQL-Clustering is failover technology and not a load balancing technology. 1. What I'm wondering is when you go for Active/Active mode, then whether both the nodes communicates with the single instance of shared device or only 1 node communicates with i...more >>

Our server team has set up an EMC Clarion SAN with 3 sets of RAID 5 arrays, several RAID 1 arrays and other drives/arrays for snapshots. The first server we are installing has the data going to an 80 GB slice an an 8 disk RAID 5 array and the logs going to a 20 GB slice on a 5 disk RAID 5 array. ...more >>

This past weekend I was challenged a little in resolving what I hoped was a simple collation issue. We are running Win2K3 Ent. Clustering Services, SQL Server 2000 Enterprise, b.8.00.760. On Friday, 2.11, a user migrated an application to this new clustered setup and immediately received th...more >>

Does clustering supports dynamic disk mirroring with SAN? As cluster has single point of failure of disk, we want to mirror the databases. Any ideas would be appreciated. Thanks ...more >>

Hello, I developed a win32 .exe CGI that connects to a clustered SQLServer to report some data. The software is written with Borland C++Builder. This is the oledb string: Name=Provider=SQLOLEDB;Password=xxx;Persist Security Info=True;User ID=xxxx;Data Source=xxxxx;Initial Catalog=xxxxx;Network...more >>

Hi Just want to know possible scenarios for switching of clusters any whitepaper . for e.g. when services are stopped on one node cluster will switch or when we move the group to other node the cluster will fail what other possibilities when cluster could switch to other node . Thanks ARR ...more >>

Hi, I want to cluster my SQL server DB and just wondering what hardware (how many systems, adapters, what will be installed on what etc) will be required to do the same. We are planning to use Win2k3 "Server Cluster" service for the same. Where will SQL Server DB reside? What will be inst...more >>

I am going to be installing SP3 on an active /active cluster tomorrow and would like some help if possible. We have two virtual SQL SP2 servers (one is a named instance). I have been reading up on the documentation and all, but have not found any conclusive procedure for this installatio...more >>

Hi We recently built a W2K Advanced server, SQL Ent 2000 cluster. Each node of the cluster had 2 NIC ports: 1 NIC was used for Cross over cable Other NIC was used for LAN. All standard build servers in our environment should have 2 NIC connections - one going to our normal lan and the o...more >>

Hi, Below are few queries: 1. Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on each node) 2. Hows does the data Synchronization between different nodes of databases takes place? 3. In Active/Passive mode, does the passive node database is exactly in the same sta...more >>

Hi , I'm new to Legato Networker and am trying to get a backup of a SQL server cluster to work on W2K. Have put the -a <virtual server> option in the job an dthe user I'm connecting with is in al lthe relevent groups. Agent is installed on the cluster. But all I get is the following error ...more >>

Hi Group SYSTEM: Clustered SQL Server 2000 on Windows 2000 (2 servers), with RAID 1+0, 6 drives (Total of 24 20GB hard drives with mirroring/striping). 4 GB RAM / Server. All fiber back end, with Fibre Channel Storage Hub 7 ( @ 100 MB/sec ). Our SQL servers have fiber cards @ 400 MB/sec ...more >>

Hi there. I am having problems with MSDTC on a 2-node clustered server. I currently have it added as a resource in a group with disk storage, SQL Server, an IP Address and a Network name. When I look at the status of MSDTC using MSSQL Enterprise Manager on either node, it seems to be runnin...more >>

Dear All, I have recently setup an active-active Microsoft SQL 2000 cluster on Windows 2003, and I am starting to wonder how such a setup can reach the target of 99.99% availability, i.e. 52 minutes and 33 seconds downtime per year! I know that I should have made some research before, but I w...more >>

Verifies of my backup jobs are repeatedly failing from "Cannot Open Device" errors on my new Win2003 cluster when run from the maintenance plan job. When I try the path, it is valid and I can run the verify statement manually for the file and it completes successfully. Has anyone encountered thi...more >>

Hi, Due to re-engineering of our Network infrastructure, we need to change the SubNet Mask Properties in the SQL Virtual IP resource. We are using SQL 7.0 clustered on 2 Active & Passive nodes. The SubNet masks and Gateway of the 2 nodes also required to be changed. IP address remain the sa...more >>

Hi We are running SQL server in a cluster environment and Hyper threading are enabled in that servers. The application and Database servers are different. The appliactions stores 2 MB size of acrobat files to the table which contains more than 600000 records . We are finding some kin...more >>

Hi, I was told by someone that after install clustering SQL Server 2000 named instance, it must remove that before installation made the alias. Is that necessary? What if I leave the alias named instance in the server? Thanks! -Chen ...more >>

Hi, After a few frustrating hours yesterday of continually seeing this error message when trying to install an instance of SQL2000a on to Windows 2003 cluster I managed to get it to work. In my case the answer was simple, on both nodes copy the entire SQL2000a install directories to c:\SQL20...more >>

Hi there, i am briefed with the setup of a multi node Cluster Sql system containing 4 nodes with 3 active and 1 passive node using HP DL380s and a HP EVA 3000 SAN with FC switched fabric. Now i am looking for documents and whitepapers helping me doing the job. Unfortunately multi node...more >>

Hi ! I have win 2000 A.S. with SQL enterprise edition in an active/active configuration. Is it possible to to restore a backup of sql bases (master, etc) on a same hardware configuration, but with virtual server sql renamed ? It's the 1st time I come on this Msnews : very interresting ! ...more >>

Hi I need to increase performance of our SQL enviroment and i dont really want to put one BIG server in. What would be the best way of load balancing 1 SQL database over 2 servers? My first thought was 2 servers clustered with a SAN and use SQL replication between two differant Instance...more >>

Hi there. I'm new to this clustering mularky and I've a couple of questions regarding a linked-server query I have. 1. Server A is a regular server. Server B is a clustered server with shared storage. From A, I want to call a stored proc that sits on B. Q: I need to add B(cluster) as a Link...more >>

We want to upgrade our two nodes active/passive cluster from 3.5 GB RAM to 6 GB. We add the RAM in the passive node first, set the /PAE switch and restart window. We then failover the Cluster Resources to the passive node. However, the operation failed without giving me any error message in Ev...more >>

We have had a working SQL Server 2000 SP3 (default instance) on two node MS Windows 2000 Advanced Server with MS Cluster servcie working for over a year now. The shared Q: and E: drives are actually two seperate LUNS from a SAN connected via Host Bus Adapters.. Recently, needed another logi...more >>