I have a question about single node clustering and after some time adding the second node... The situation: We have a Compaq DL580 server on a SAN...

Gé Brander

10-08-2003 06:43 PM
Cindy Gross

Verify that the admin$ share still exists on both nodes. Also, the setup files should be on the local drive of the node you are running setup...

Eduardo Lecuna

10-08-2003 06:26 PM
Cindy Gross

Hi; SQL 2000 Enterprise Windows 2003 Enterprise - Clustered (2 node) I have installed a Virtual server with one instance successfully (named...

Kami

10-08-2003 06:18 PM
Cindy Gross

As i found W2k3 cluster can be done without shared disk. Majority Node Sets enables this configuration. This is as Q: Is it SQL2000 can be installed...

Alexander

10-08-2003 03:39 PM
Rand Boyd [MS]

My SQL 7.0 database server is running in MS cluster service with Active/Passive mode. Two nodes are Compaq servers with disk array storage. I now...

Andy Nguyen

10-08-2003 09:28 AM
Rand Boyd [MS]

Please Advice I run sql 2k sp 3 on win 2k on sp3 in an active/active cluster configuration. SQL server error log reported these errors. Unable to...

Olutimi

10-08-2003 09:26 AM
Rand Boyd [MS]

Hi, Does anyone has experience with the SQL Server error log with following message: Failed to obtain TransactionDispenserInterface: Result Code =...

Jenny

10-08-2003 09:20 AM
Rand Boyd [MS]

In article <248c801c38cfc$c515e6e0$a601280a (AT) phx (DOT) gbl>, yao <yvesmensah (AT) hotmail (DOT) com> writes It will already be using 1434 as...

Darren Green

10-08-2003 09:07 AM
Rand Boyd [MS]

Hi, I have setup Microsoft sql 2000 on a cluster environment running on a windows 2000 Advanced server. The problem I am having has to do with the...

yao

10-07-2003 12:59 PM
yao

merong, In the Knowledge Base, there are numerous SQL Server 2000 KB articles that respond to the search criteria, "distributed partitioned...

Ron Talmage

10-07-2003 02:27 AM
Ron Talmage

We are preparing to bring our customer to-date online and we are facing some challenges. Currently all our customers have about 100-150 customer...

Richard Douglass

10-06-2003 03:34 PM
Richard Douglass

Have you implementated SQL Server 2000 in cluster with more than two nodes? I'm testing SQL Server 2000 and Windows 2003 in cluster with tree nodes...

Marcos Vinicius

10-06-2003 01:43 PM
Geoff N. Hiten

I'm considering distributing a large table which we now have, for performance reasons. We've been doing a join on this large table (11...

Andrew

10-05-2003 09:27 AM
Andrew

Are you thinking of Geographic Dispersed Clustering? If you do not Microsoft Clustering, you could try SQL UP product that allows you to...

Sérgio Monteiro

10-04-2003 02:20 AM
Aaron Perez

What are the special settings that need to be set for a Active/Active Cluster? Thank You Mickey mautry (AT) ev1 (DOT) net

Mickey

10-03-2003 04:34 PM
Steve Schofield

Has anyone had any experience with Geographically Dispersed SQL Server 2000 clusters? We have a SAN which provides realtime replication to an...

Dave

10-03-2003 03:17 PM
Dave

I have seen some docs on installing Win2K clustering services but need to find a step by step document that talks about installing the OS on the...

FR

10-03-2003 07:56 AM
GA

To revert to an pre-sp3/a system, Is it necessary to reinstall windows cluster also ? Steve

Steve

10-02-2003 11:10 PM
Linchi Shea

I am getting this error on our Cluster active-passive SQL Server 2000 Enterprise Server. Can any one help! Thanks, Katherine 2003-10-01...

Katherine

10-02-2003 01:34 PM
Geoff N. Hiten

have a win 2k adv active-active with SQL 2k Ent. the failover works great. However i noticed that on the other active node, even with AWE enabled,...

Corey

10-02-2003 12:48 PM
Geoff N. Hiten

Hi, can someone help with this... I tried to install sql server enterprise version on windows 2k advanced version with sp3 without much success....

Peter Dam

10-02-2003 02:14 AM
Pete

Hi Tom: I had a similar problem. Take a look at this: http://support.microsoft.com/?id=815431 This solved my problem.. make sure after you...

Kami

10-02-2003 02:11 AM
Pete

Does anyone know what Microsoft recommends for the location of Tempdb when using SQL clustering?

jtav

10-01-2003 11:16 PM
Linchi Shea

Hi, Our Cluster server is up with active/active settings. Now, we need configure one SAN drive to make it size big, and this drive contains master,...

Jenny

10-01-2003 12:44 PM
Geoff N. Hiten

Yes, the master databse is the same. Rand

Rand Boyd [MS]

09-30-2003 11:50 AM
Rand Boyd [MS]

Hello All & Greetings. I am writing this about Creating FileGroups for an existing DB If it is in a Clustered environment , I would like to know of...

RK

09-30-2003 10:59 AM
RK

If you do this, obviously your SQL instance will be off line. And you may screw things up in the process if you are not careful. Keeping an...

Linchi Shea

09-30-2003 07:49 AM
Jenny

Hi I'm a bit lost will all the requirements for changing my Active / Passive Cluster to Active / Active.... Currently I have - Compaq CL380 Dual...

Colin A

09-29-2003 10:28 PM
Linchi Shea

Hi all The problem occurs when the cluster service attempts to take ownership of the quorum disk. The other node in the cluster is turned off, but...

Felix Burkhard

09-29-2003 10:24 PM
Linchi Shea

SQL Server 2000 Enterprise Manager cannot see my e-drive, which consists of two drives mirrored to appear to be one physical drive. However, this...

Chari

09-29-2003 10:18 PM
Linchi Shea

You can it either with Server Network Utility or the EM. The end result is the same. Yes, the cluster will take care of replicating the...

Linchi Shea

09-29-2003 10:16 PM
Linchi Shea

Yes, you can run a different service pack for each instance. In fact, when you apply a SQL service pack, you have to apply it to each...

Linchi Shea

09-29-2003 10:12 PM
Linchi Shea

Hi, Our clustering server needs configure the SAN G drive (make it big size), the problem is that G drive contains master, msdb, model, and tempdb...

Jenny

09-29-2003 09:12 AM
Jenny

Can I some how share a disk resource between two nodes in active/passive failove cluster configuration? I need a disk wich owns active node to be...

Gabriel

09-29-2003 01:32 AM
Sérgio Monteiro

hi, I have a new cluster and I need to move(copy) the databases about 100 of them to the new cluster leaving the old cluster functioning intact.will...

Fredy

09-28-2003 08:48 PM
Linchi Shea

I have a Windows Server 2003 Enterprise Edition cluster up and running correctly. I am trying to install SQL Server 2000 on a virtual server. ...

Peter Lyons

09-26-2003 12:50 PM
debbie

Yes you will need to install service pack 3 after installing a different virtual or non virtual instance. Rand

Rand Boyd [MS]

09-26-2003 12:04 PM
Rand Boyd [MS]

Actually, both active/passive and active/active are covered throughly in the BOL, and various Microsoft high availability whitepapers. Regardless of...

Linchi Shea

09-25-2003 09:49 PM
Linchi Shea

Hi We are running a SQL 2000 cluster and using a SAN for our storage. We have dedicated a volume G for datafiles, F for logs, and H for backup...

Adrian Fivaz

09-25-2003 02:51 PM
Geoff N. Hiten

Hi, Does anyone have experience wrt installing sql ce 2.0 server components on a 2 node sql 2000 clustered server (active/passive config)? Any info...

jago taylor

09-25-2003 04:34 AM
jago taylor

Hi; I have a clustered SQL server (2000) on a Server 2003. Initially the IP address used for the setup was an internal IP address and now we want to...

Kami

09-24-2003 08:11 AM
Kami

Hi, Currently the cluster has only the default cluster group.I understand that this is not recommended as , if one resource fails , the entire...

Daijon

09-23-2003 06:09 PM
debbie

I have started noticing the following problems with my sql 2k sp 3 cluster. Occassionally it will hang up(other processes can't connect to it). I...

Jeremy

09-23-2003 06:05 PM
Jeremy

We are setting up a SQL Server 2000 Cluster Server would like to know the counters that should be monitored and send Alerts to the DBA when they have...

Mickey

09-23-2003 05:30 PM
debbie

I setup perf mon for a SQL7 on winnt 4 cluster server. There are counters for physical disk, i.e. avg. reads/sec, etc. But I could not see any chart...

mike

09-23-2003 04:54 PM
Sérgio Monteiro

Without going to Cluster Administrator, is there a way (e.g., using Query Analyzer) to determine which node in a cluster an instance is running on?

Bob Browning

09-23-2003 12:18 PM
Linchi Shea

Thanks, that is actually something I want to know about more...how do you make an obfuscated email address? Can you even do one with a freebie...

Andy Svendsen

09-23-2003 12:13 PM
Andy Svendsen

I have one cluster Manager (2 servers A & B) with 2 SQL2K servers (SQL2K1 & SQL2K2). Is it possible to configure my setup to force my SQL2K1 to run...

Rem

09-22-2003 03:54 PM
Darren Green

We did change the addresses some months ago. I am not sure how long this problem has existed. Because connections with named pipes has worked, it...

David Knapp

09-22-2003 10:51 AM
Dave K.

We have a large project going on at the moment to migrate to Active Directory. All of our application servers are being migrated out of an...

Tony Lewis

09-22-2003 10:09 AM
Geoff N. Hiten