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...

C-Ya

02-21-2005 06:52 PM
Mike Hodgson

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...

Pankaj

02-21-2005 01:43 PM
Pankaj

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...

Dean

02-20-2005 04:47 PM
Al

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...

ChrisR

02-20-2005 03:52 PM
Mike Epprecht \(SQL MVP\)

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)...

Pankaj

02-18-2005 07:11 PM
Pankaj

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...

Andrew Gilbert

02-18-2005 05:59 AM
Mike Epprecht \(SQL MVP\)

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...

Stefan Demelhuber

02-17-2005 06:32 PM
Rodney R. Fournier [MVP]

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...

Chinna Kondaveeti

02-17-2005 04:19 PM
Chinna Kondaveeti

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...

Pankaj

02-17-2005 12:38 AM
Geoff N. Hiten

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...

tram

02-16-2005 10:08 AM
Geoff N. Hiten

Hi Has anybody used Doubletake on there SQLcluster for bit level replication of data. I have been told that Microsoft use it on there SAN's. Thanks

Darrel

02-16-2005 07:05 AM
Darrel

Hi, We plan to install/setup 3-4 node SQL Clustering using Windows 2003 (Enterprise Edition)/SQL2000 (Enterprise Edition) on SAN (EMC) we plan to...

Kamal Hassan

02-15-2005 11:07 AM
Kamal Hassan

Yes is not a default SQL instance, I forgot to mention. The address is xxx.xxx.xxx.xxx\instance But then, If he has disabled UDP, why it works the...

mdurliSPAMFILTER@hotmail.com

02-15-2005 03:15 AM
Mattia

Is there a way to determine the currently active node in a cluster? I would prefer to use .Net to determine which node is currently active. Anybody...

ben

02-15-2005 12:40 AM
magicgirl83

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...

Aju

02-14-2005 03:19 AM
Aju

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...

Shane

02-11-2005 11:28 AM
Geoff N. Hiten

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...

02-10-2005 11:52 PM
Rodney R. Fournier [MVP]

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...

Tim

02-10-2005 10:18 AM
Andrew J. Kelly

Hi, I have a problem when I start de Profiler (Tuning template) on Windows 2003 Cluster server with SQL Server 2000. Can someone help to solve this...

Ganendran

02-09-2005 03:51 PM
Ganendran

Verifies of my backup jobs are repeatedly failing from "Cannot Open Device" errors on my new Win2003 cluster when run from the maintenance plan...

Tech Witch

02-09-2005 01:54 PM
Tech Witch

Hi We are running SQL server in a cluster environment and Hyper threading are enabled in that servers. The application and Database servers ...

Swami

02-09-2005 10:13 AM
Geoff N. Hiten

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...

Andrew Gilbert

02-09-2005 09:50 AM
Geoff N. Hiten

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...

kcThong

02-08-2005 10:39 AM
Rodney R. Fournier [MVP]

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,...

manu mimil1

02-05-2005 09:41 AM
manu mimil1

When connecting to SQL 2000 in my clustered environment, Enterprise Manager seems to run slowly when expanding database info from the...

webmm

02-04-2005 03:37 PM
webmm

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....

len

02-04-2005 07:38 AM
Rodney R. Fournier [MVP]

"Ed Woodrick" <ewoodrick (AT) ed-nospam-com (DOT) com> wrote The problem here is that if they are brought up at the same time, you may have...

Russ Kaufmann

02-03-2005 07:37 PM
Russ Kaufmann

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...

Gavin Chan

02-02-2005 07:53 PM
Gavin Chan

Hi all, I have a windows 2003 cluster with sql-server 2000 sp3 and a named instance. I wanted to installation the hotfix ..859, but the installation...

liebesusn@web.de

01-31-2005 07:36 AM
Rodney R. Fournier [MVP]

Does anyone have a good diagram? I have seen for single instance cluster at microsoft site. Thanks

Uma

01-30-2005 07:11 PM
Uma

Hello everyone... I'm trying to setup publishing on my 2 SQL servers for backup purposes. Main SQL server - (win2k)2 node clustered sql server with...

knoche

01-28-2005 08:35 PM
Steven S. Warren

Hi all, we have a w2k3ee server cluster running one instance of exchange as failover cluster. We now would like to use the passive node for a sql...

carsten lahme

01-28-2005 03:11 PM
Rodney R. Fournier [MVP]

Hello, I am not sure how to approach this problem. What I need to do is setup failover as well as data copying. I need to setup clustering on two...

bk29

01-28-2005 12:59 PM
bk29

Hello: I'm wondering if merge replication with PDAs works throught a Clustered server. I think the sql server agent sscesa20.dll doesn't work...

Juan

01-28-2005 08:00 AM
Juan

Hi, I have a scenario which works fine on a non-clustered SQL server, and I now want to implement it on a clustered SQL server. In a stand-alone,...

John [412075]

01-27-2005 05:37 PM
Rodney R. Fournier [MVP]

My friends: I need document information about the installation process of SQL in Cluster with two instances, both active, one in each Server. In...

Carlo Sorrel

01-26-2005 01:45 PM
Mike Epprecht \(SQL MVP\)

Hi Guys, I AM USING DISTRIBUTED TRANSACTION WITH sql server 2000 on win2k working fine. but the same transaction not working in win2k3. i am...

bijupg

01-26-2005 11:31 AM
Geoff N. Hiten

I also have two matched servers with Win2003EntSrv that I would like to install an active/passive failover cluster of Yukon on. Since this is a...

al_stark_born

01-26-2005 10:52 AM
Rodney R. Fournier [MVP]

Microsoft SQL Server 2000 SP4 is open for Public Beta Testing Sign up to test drive the newest service pack for SQL Server 2000 give us your...

Tara Nerurkar

01-25-2005 05:56 PM
Tara Nerurkar

Ryan, thanks for that , good to hear someone using a similar config to ours is not having probs. We are using McData switches. Hear you re Firmware...

Andy Ball

01-25-2005 03:13 PM
Andy Ball

I just set up a cluster attached to a SAN. I have had it where the cluster service on one of the nodes doesn't start up right away. I have checked...

Thomas

01-25-2005 12:51 PM
Geoff N. Hiten

Hello Andrew, The recommendations are based on the following KB article and also supporting customers with similar configurations that have faced...

Shashank Pawar [MSFT]

01-25-2005 11:35 AM
Fiona H

just a quick background SQl 2000 running as a cluster. We started a merge replication and had problems so i removed it. we had probelems with the...

bradchand

10-28-2004 05:44 PM
bradchand

Hi, I have to move an entire SQL Server system databases from current basic drive W: to new SAN drive H: in cluster server (current is one node with...

Chen

10-28-2004 12:25 PM
Chen

What is the Best Practices way and quickest way to move a SQL Server 2000 Virtual Server database to a new server. This a production server with...

Joe K.

10-27-2004 12:17 PM
Joe K.

I have a very basic question regarding nodes in MSCS running sqlserver2k. I'm trying to understand what it means to load-balance. I thought...

Robert

10-27-2004 11:10 AM
Greg D. Moore \(Strider\)

I have documentation for Win2K which says run comclust.exe to add MSDTC . Running the same brings up the Admin window. Please point me to some...

Alfred

10-26-2004 11:54 PM
Uttam Parui[MS]

Hi I am getting the error message listed below while starting my SQL Server on a cluster node, the server is up and running just the sql server is...

Rodger

10-26-2004 08:59 PM
Tracy

Hi! I have a server I am planning to cluster. I will be using the same SQL server name for this cluster. I have a large number of...

Roust_m

10-26-2004 11:15 AM
Geoff N. Hiten

SSL in won't work under Domain User account. MS Fix buletin does not help at all. Please Help!! Hi, I have set up an Active Directory, Certificate...

Jason Robertson

10-25-2004 06:21 PM
Jason Robertson