Hi All: I am upgrading to SQL SP3a from SQL SP2 in a SQL2K dual node cluster environment W2K SP4 is the current OS. I have no test environment...

Eric H

09-16-2004 08:21 PM
Calvin Do

is there anywhere i can get a step by step order for installing an active/passive sql2000 cluster on a win2k3 platform that shares an attached san...

jay mack

09-16-2004 02:38 PM
Geoff N. Hiten

(that you call active) and another test clustered SQL Server instance on second node (that you called Actually, the test instance of SQL would not...

Dan D

09-16-2004 02:24 PM
Dan D

The Window Server team would like to invite you to an upcoming chat: Title: How to write a cluster resource DLL This chat focuses on how to write...

Shon Shah [MSFT]

09-16-2004 12:48 PM
Shon Shah [MSFT]

I am running a multiple instance cluster. Each server has 8 CPUs with 16GB ram. I have a database on each server active where if one node fails,...

marine

09-15-2004 11:46 PM
Greg D. Moore \(Strider\)

We have a server in Central time zone and another server in Pacific Time Zone. Q: We were very successfuly during logshipping from Central 2...

SQL-Tips

09-15-2004 09:44 PM
SQL-Tips

in an active/active clustering, do the two nodes have the instance of sqlserver with the same name ? can we say that we were serving on two hosts...

ilkozer

09-15-2004 12:51 PM
Geoff N. Hiten

This is my first cluster setup. I have two identical servers, a RAID array, Wondows 2000 Server Advanced and SQL Enterprise. All new hardware and on...

OldDogNewTricks

09-14-2004 08:33 PM
OldDogNewTricks

I have a couple clusters (each with eight processors total, and 16 GB RAM total), but am not getting the performance desired. I "inherited" these,...

Adam Freden

09-14-2004 02:07 PM
Geoff N. Hiten

Hi all, i must upgrade the RAM from 2 GB to 4 GB on the Windows 2000 ADV Cluster A/P on both node. There is any problem with the cluster service or...

09-14-2004 09:20 AM

Guys/Gals With all the 3rd party tools available out there to achieve some level of High Availability, why would one still consider Clustering i.e....

Hassan

09-13-2004 10:19 PM
Shashank Pawar [MSFT]

Hi all, I have a two-node database cluster built on Windows 2000 AS. After rebooting one of the nodes for updates, it started to reboot on the...

Eric Caron

09-13-2004 07:26 PM
Eric Caron

Cluster services gives the high availability needed - that is great. But I have never seen any discussion about what happens when a node fails - what...

gotdough

09-13-2004 12:04 PM
Geoff N. Hiten

I am attempting to upgrade SQL2000 enterprise edition on Win 2000 advance to a clustered default instance. I run SQL setup as per the books...

Ulf Lundqvist

09-13-2004 05:35 AM
Ulf Lundqvist

I need to add a second node to a SQL Server Cluster. What i have to do? I have join the second node using Cluster Administrator. I don't see any...

SP

09-13-2004 12:14 AM
Chris Skorlinski

Is it possible to setup a second instance of SQL Server Enterprise on a box and setup clustering? I have someone asking me that has only one Server...

Erik Grob \(MCP\)

09-12-2004 11:51 PM
Chris Skorlinski

Hi, I have a big doubt about... We have near 20 dbs with many applications that work with. During the days there are many problems about...

opianeta

09-12-2004 11:47 PM
Chris Skorlinski

I've just installed clustering on a pair of Intel Itanium boxes running 64 bit Server 2003 Enterprise. I've followed the setup instructions in...

Jezza

09-12-2004 10:39 PM
Rodney R. Fournier [MVP]

We have just setup two servers running a copy of SQL 2000 on Windows 2000 server. Each of these servers is running vendor software that...

Karl Albrecht

09-11-2004 05:30 PM
Rick Collins

SQL Mail is not cluster aware on a failover, but having it is better than not, I believe. What tasks can be scheduled to check for the proper...

anonymous

09-11-2004 06:15 AM
Luca Bianchi

We would like to implement 2 node active-passive clustering coupled with log shipping. Clustering is for high availability and log shipping for DR...

barbara

09-10-2004 09:41 PM
Greg D. Moore \(Strider\)

Have a look here: http://www.aspfaq.com/show.asp?id=2461 -- Andrew J. Kelly SQL MVP "SQL Server on Windows server 2003" <SQL Server on Windows...

Andrew J. Kelly

09-10-2004 08:23 PM
Curt Spanburgh

You can emulate clustering through VMWare. -- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE,...

Tom Moreau

09-10-2004 08:58 AM
Tom Moreau

We just installed a SQL 2000 instance in a 2 nodes W2003 cluster. The services are running with a domain account which is local administrator on both...

09-10-2004 06:01 AM

I joined a company as a DBA the company has cluster servers set up. I was given the 3 ip addresses. i for the cluster and 2 for for the ones...

Nik

09-08-2004 05:54 PM
Rodney R. Fournier [MVP]

Because clustering is too expensive for my company I'm looking for an alternative disaster recovery solution. I am considering setting up...

Mike Colella

09-08-2004 11:54 AM
Geoff N. Hiten

My teammate and I recently moved a working SQL cluster into a datacenter. We are using Win2k3 Server and SQL 2000. The problem is that I have a...

Sam Hack

09-07-2004 09:46 PM
Sam Hack

we are going to cluster our sql server as we are becoming the 'data center' for operations here. we are getting 2 new 6650's which i would like to...

menard

09-07-2004 11:58 AM
menard

Is there a way to find the actual physical server name that the clustered instance of SQL is running on. I am setting up a failover to a ModelOffice...

Thom

09-06-2004 01:19 AM
RR News

Hi, I need to move a MSCS cluster running SQL Server 2000 Enterprise Edition to a new subnet. Can anyone point me to or list what items I need to be...

Jose Lopez-Alvarez

09-03-2004 10:29 PM
Rodney R. Fournier [MVP]

If a customer has a na application that accesses SQL server running on a single machine (Windows 2003 Server) and then decided to implement an...

09-03-2004 10:08 AM
SqlJunkies User

I am trying to setup a virtual SQL 2000 instance on Windows 2k3 Ent. I have drives presented from the SAN and a Quorum disk and they can all...

Jason C

09-03-2004 08:17 AM
Jason C

Hi, Would it be safe to say that SQL server does not allow me to do load balancing of a single database? We have an application that uses a...

Dragon

09-03-2004 01:17 AM
Chris Skorlinski

hi all , I tried several times to install sql clustering on two sql nodes but when it tries to configure the resources on virtual server after...

Alireza G.

09-03-2004 01:11 AM
Chris Skorlinski

Ive come across this article http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog05.mspx and was interested in stretch clustering .....

Hassan

09-02-2004 04:10 PM
Andy Ball

Hi Folks: How do you script-o-matically set processor affinity on SQL after a cluster failure? The purpose is that I'll be failing to a machine...

The Researcher

09-02-2004 10:23 AM
The Researcher

How many Ressource group or Virtual SQL server may I run on on Windows 2003 cluster node ? How many nodes can I have for an SQL Cluster architecture...

Jean-Michel Remiche

09-02-2004 09:42 AM
Geoff N. Hiten

Does anyone have a guide for setting up a 2 node active/passive cluster with SQL Server? I want to try it in a VMWare GSX/ESX environment to learn...

Niklas E

09-01-2004 04:41 PM
Claudio

We recently set up an Active/passive SQL Server 2000 Windows 2003 Cluster for our customer. They ran their SQL client application which was doing...

09-01-2004 01:00 PM

Hi This is sort of a repost of my previous posting, but I think the problem is better explained in this one. I have a windows 2003 cluster with two...

Jan Eliasen

09-01-2004 11:28 AM
Stephen Dybing [MSFT]

I wanto to make a SQL cluster using VMWare Workstation 4.5. I need to create a SCSI shared storae device to use witj my cluster. How can i make...

SP

08-31-2004 07:46 PM
Niklas E

We have a cluster server with 2 nodes, both running Win2000 Advanced Server. However the second cluster had to be wiped and rebuilt from scratch. We...

Kevin

08-31-2004 03:32 PM
Walker Duhon[msft]

Hi, We are looking for failover strategy when primary server failed using log shipping method. We are not using sql server clustering. What is the...

barbara

08-30-2004 04:41 PM
Rony Thomas

Hi, Our customer wants to go from a standalone SQL server implementation to a clustered one. We recommended Active/Passive for them since they do...

08-30-2004 03:38 PM
Geoff N. Hiten

I have a system configured with Windows 2000 and SQL Server 2000 Clustering (active/passive). Both SQL Servers have a local E:\ drive with the same...

Douglara

08-30-2004 08:04 AM
Rudi Bruchez

I have Windows 2000 Advanced Server with SQL Server 2000 with SP3A in a Active\Active Cluster. When I loaded Windows 2000 SP4 on the server it...

Mark

08-29-2004 03:38 AM
Andy Ball

I would like to know the kind of test to be done after the fresh installation of SQL Server on cluster environment. This to ensure the fail over...

Siva Prasad [SIVA]

08-28-2004 12:36 AM
Steven S. Warren

looking at doing this , and wonder if anyone here had some observations / experiences they would like to share. cheers, Andy.

Andy Ball

08-27-2004 12:22 AM
Andy Ball

I'm having a "PackageForTheWEB" error when installing MSSQL 2000 in Windows 2000 advance server. It seems that mssearch is the cause, what ca I do?

Janz

08-26-2004 09:39 PM
Janz

I have a SQL Server 2000 with SP3 in a Active / Active Cluster. I would like to write a SQL query to receive database table data from the other side...

Mark

08-26-2004 11:49 AM
Geoff N. Hiten