Hi, Can you brief me/ point me to a document to set up a fail over using 2000 or 2003. We are looking for a fail over solution for our sql server...

David Velacso

02-10-2004 05:12 PM
Andrew J. Kelly

Is it possible to use Windows 2003 clusters to have 2 active nodes, each with a completely independent virtual server/instance of SQL 2000 and...

Jason

02-10-2004 03:49 PM
Allan Hirt

Can an Active/Active SQL Cluster, built on two 4-processor boxes, act as one SQL Server with 8 processors?

Rick

02-10-2004 03:00 PM
Geoff N.Hiten

Well, there are two levels of fragmentation: logical and physical. Within the SQL DBs, there would be logical and that is normal SQL maintenance. I...

Allan Hirt

02-10-2004 11:19 AM
Allan Hirt

Does anyone know how much disk space MSDTC requires when adding to a cluster group? Does it depend on the size of the enlisted transactions??

Stephen Strong

02-10-2004 11:16 AM
Allan Hirt

Whenever Internet link is down, the user cannot connect to SQL server 2000. The SQL Server 2000 is installed on Win23K Cluster server. When checked...

Balaji

02-10-2004 11:14 AM
Allan Hirt

Hi. I posted the message below in microsoft.public.sqlserver.setup & microsoft.public.windows.server.setup and was advised to also post...

Mark Jerde

02-10-2004 11:13 AM
Allan Hirt

Would it be possible to create SQL 2000 instance on Windows 2003 Majority nodes set? I have two test seperate servers that need to be...

Kevin Kim

02-10-2004 11:04 AM
Allan Hirt

Hi All Is the SQL Post SP3a cumulative recently released by Microsoft Cluster aware? If not, does one apply it to the standby node first, then force...

J

02-09-2004 04:55 AM
Shirley Kelly [MS]

I have a database on the passive node that frequently gets marked "suspect." I'm looking for any insight as to why this might happen, as well as how...

Troy Laughlin

02-07-2004 02:12 PM
Kalen Delaney

Is there any issue with building a cluster with 2 nodes (Active-passive)and with different hardware spec (but same mem size, different number of...

Bret

02-06-2004 01:26 AM
John Toner [MVP]

I have a Windows 2000 Advanced Server clustered with SQL Server 2000. I am using NETIQ DiagnosticManager for SQL Server for monitoring and alerts. ...

Dean

02-05-2004 07:10 PM
Dean

Hello, I would like to know your opinion about running 4-8 SQL 2K instances on each node of a multi-node (2) cluster, with 8 production databases on...

Rinus Heer

02-05-2004 04:36 PM
Stephen Strong

We have our 2 node SQL Server 2000 Cluster connected to a NAS device. We have created 4 LUNs, 2 for each node, with one DATA and one LOG. On the...

Michael [multnomah]

02-05-2004 04:26 PM
Stephen Strong

Look at the cluster service on the 'bad' node. If communication is good but the node appears down, it may be the cluster service is having...

Geoff N.Hiten

02-05-2004 03:26 PM
RunninMan

Would like step by step instructions for setting up windows 2003 and SQL 2000 clustering services. I also need instructions on installing the OS...

sql

02-05-2004 02:56 PM
Geoff N.Hiten

Hello, I have sql 2K on cluster Windows 3K but when i do a backup report this message on eventlo Event Type: Erro Event Source: MSSQLSERVE Event...

hmendez

02-05-2004 10:21 AM
Hmendez

I am in the planning process of upgrading the hardware on our cluster. I need info/advice/suggestions on how to go about this. I am running an...

Viraj

02-04-2004 10:49 AM
Chandrasekar Gopalan

First, thanks in advance for any help you can provide! SITUATION: Two Win 2003 Enterprise Servers, fully updated Active/Passive SQL Server 2000...

Jim Rackley

02-04-2004 08:51 AM
Jim Rackley

Hi Guys, IN MY SQL SERVER 2000 database i heve some tables holding 20 million rows i want to archive this tables . but while taking reports i should...

biju george

02-04-2004 03:01 AM
biju george

Hello all - I've 'inherited' the sysadmin position for our company's online parts store. This is driven by the following: 2 Dell 2650's as Nodes 1 &...

randyvol

02-03-2004 04:51 PM
JimPSU

Hi All, I had two Window NT 4.0 Server, say A and B... We recently upgraded from MS SQL Server 6.5 to MS SQL Server 2000 on Computer A, and...

kim

02-03-2004 01:30 PM
Cindy Gross

Enter the Windows Server 2003 Challenge for your chance to win a grand prize worth $15,000 USD! 1st Round ends February 15, 1004 Tell us how...

Windows Server 2003 Challenge

02-03-2004 12:11 PM
Windows Server 2003 Challenge

Hi, We have two machines running SQL Server 2000 SP4 and Windows 2000 Advanced Server SP4. Both have processors P4 2.4 HT with 4GB RAM. This two...

Pedro Henrique

02-02-2004 10:18 PM
Pedro Henrique

I have trouble installing default as well as named instances og SQL Server 2000 on Windows 2003 cluster. I've tried on a couple of different systems...

Ole

02-02-2004 04:45 PM
Ole

I am in the planning process of upgrading the hardware on our cluster. I need info/advice/suggestions on how to go about this. I am running an...

Jeff

02-02-2004 04:13 PM
Geoff N.Hiten

Thannks in advance for an help on this. I am attempting to set up SQL2K EE on Win2003 cluster (active/passive). I get this error msg "Setup failed...

John Marks

02-02-2004 03:10 AM
Shirley Kelly [MS]

This is unlikely a clustering specific problem. It's more likely a hardware problem in your disk subsystem. I'd do what the BOL recommends with...

Linchi Shea

02-02-2004 02:59 AM
Shirley Kelly [MS]

I have installed SQL Server on a new cluster. We are having problems with the SQL Server Failing Over on the Full Text service. I do not see an...

Ashley

01-31-2004 12:19 PM
Rand Boyd [MSFT]

Hi Can anybody give me some URL:s with good documents that explains how to install SQL 2000 Enterprise on Windows 2003 Enterprise (2...

news.microsoft.com

01-30-2004 10:54 PM
Yuan Shao

For 3 years I had a Windows 2000 server farm consisting of 4 servers (2 web servers load balanced and 2 sql servers for clustering). The 4 servers...

Paul Dube

01-30-2004 11:29 AM
Cindy Gross

I have SQL Server 2000 with SP3 running on a windows 2003 cluster. I need to setup log-shipping from a SQL Server 7 database server. The 2 servers...

Kevin

01-30-2004 11:08 AM
Linchi Shea

Hi, I'm trying to install a second instance of SQL Server on a clustered node, from Node B. I had to cancel the first execution of setup...

Fred Jean

01-29-2004 11:01 AM
FRED JEAN

How to set the idle timeout for the idle client connection ?

Kirit Randeria

01-28-2004 07:00 PM
Kevin McDonnell [MSFT]

Hi, I got a problem with a cluster with SQL 2000 EE. Had two servers, Win 2k Adv Ed., one of them died. Failover to node 2 worked fine. Bought...

Philippe Carignan

01-28-2004 04:26 PM
P. Carignan

I recently upgraded our server to a 2 node cluster. We installed MS SQL server, and created the virtual server necessary for the cluster failover to...

scottf

01-28-2004 02:58 PM
Geoff N.Hiten

Request for info on updating only Jet 4.0 to SP8 on a SQL 2000 sp3 cluster. Does each node need to be done separately or does in recognize that it...

Chris

01-28-2004 02:11 PM
JinHe

There was an issue with the MSMQ when upgrading Windows 2000 server to SP3 in a Clustered SQL environment. I was wondering if anyone knows if the...

JT

01-28-2004 11:16 AM
JT

I am having a hard time finding any details/caveats with installing SQL 2000 on a Windows 2003 cluster. Can anybody point me in the right...

Michael Bates

01-28-2004 06:46 AM
Gé

We have a Windows 2003 EE Cluster Node that has an attached NAS device via iSCSI for disk storage. Previously, we had two large NAS partitions,...

Michael [multnomah]

01-28-2004 05:03 AM
Thomas Solkod

My boss tells me to install 2 SQL instances on each node. This means 8 instances on 4 nodes. His reasons: a) Rather than 1 instance with databases...

Benny Koh

01-28-2004 02:21 AM
Benny Koh

The servers are W2003 Enterprise SQL is 2000 Ent sp3a Active/Passive I just finished configuring the cluster and it looks fine except SQl does not...

Mirna

01-27-2004 02:12 PM
Geoff N.Hiten

Tell us how Microsoft Windows Server 2003 and Windows Server System integrated server software has helped your organization cut costs, improve...

Windows Server 2003 Challenge

01-27-2004 01:11 PM
Windows Server 2003 Challenge

Hi, I am new with the SQL Server clustering, what do you recommend for jobs notification?

Cata

01-27-2004 11:36 AM
Cata

MDAC is a global resource for each host, so the first update will bring all host nodes to MDAC. Personally, I prefer upgrading MDAC as a...

Carlos Gonzalez - Phoenix, AZ

01-26-2004 10:13 AM
Rand Boyd [MSFT]

I´m trying to install a SQL cluster, the description of the environment is: Servers x370 IBM (4xPIII 700 MHz, 2 GB RAM, FC) FAStT200 Storage Server...

Guillermo Gonzalez

01-25-2004 10:51 PM
meena hariharan

Hello All, We have a SQL cluster in active/passive configuration. Unfortunately, our network has been having issues. More specifically, the line...

Chris Carmichael

01-24-2004 10:20 PM
Geoff N. Hiten

We just installed a new SQL Server 2000 Active/Active cluster. We are trying to connect to the database from VB using ADO using the connection...

Sue

01-23-2004 04:52 PM
Phil

Hi, I have a problem with my cluster San. I have win 2000ADV. with two nodes and a shared SAN. The problem is I created a Virtual server with...

Ahmed Hatem

01-23-2004 02:51 PM
Ahmed Hatem

Hi guys, i am running a mission critical financial system on sql 2000 active/passive cluster. right now i have only cluster failover and...

biju george

01-23-2004 08:20 AM
Allan Hirt