I have the following configuration 2 IBM x335 1 FASTT200 HA 1 Disk Array RAID 10 - 1 Partition (Drive S:) 1 Disk Array Raid 1 - 2 Partitions...

Greg Boyle

01-23-2004 08:15 AM
Allan Hirt

I have a two-node Active/Passive SQL Server Cluster on Win2k AS and SQL2000. When I attempt to manually failover to node 2 of the cluster all of the...

Johnnie Scott

01-23-2004 08:11 AM
Allan Hirt

Can Exchange Server 2000 & SQL Server 2000 can be installed in one cluster group? I have 2 node cluster and I plan to install both Exchange & SQL...

sim

01-23-2004 08:06 AM
Allan Hirt

Question: How to Clustered both SQL Server 2000 and MS Exchange in One Server? You know I have a machine server which i would like to configure MS...

Christian

01-23-2004 08:05 AM
Allan Hirt

I have a problem with my SQL cluster. One Windows 2000 server had a disk crash recently so I decided to reinstall it all under Windows 2003. So now I...

Paul Dube

01-22-2004 04:01 PM
Geoff N. Hiten

Scenerio: I have an active/passive 2-node clustered SQL Server. I am connecting to the virtual machine via Computer Manager and creating a local...

Matt

01-22-2004 12:23 PM
Rand Boyd [MSFT]

Hi - we would like to perform a test sql cluster setup (on two machines) and don't have an external drive array. We do have a some compatible...

Christian Bouche

01-21-2004 07:22 PM
Steven S. Warren

Hello. We have a QAT SQL Server 2000 2-node Cluster running on Windows 2003. The first node, QAT1, has a single Virtual Server . The second node,...

Michael [multnomah]

01-21-2004 06:32 PM
Kevin McDonnell [MSFT]

We are running SQL Server 2000 Enterprise Edition on our PRD SQL Server Cluster. We have two nodes, PRD1 and PRD2. PRD1 will have one...

Michael [multnomah]

01-21-2004 02:17 PM
Darren Green

Environment: SQL Server 2000 SP3a on W2K Advanced Server SP4. 1 IBM Server x440 with FastT700 Storage (Fibre Channel) We need to buy another IBM...

Franco

01-21-2004 10:40 AM
Geoff N. Hiten

We have 2003 server and cluster running on 2 nodes. Each node has 4 GB RAM. Each node has one instance of SQL Server 2000 ent. Recently we...

Linda

01-21-2004 10:28 AM
Geoff N. Hiten

Hi GUYS, in my sql server recently i am getting high Avg. Disk Queue Length of 40 for an array of 4 disks in every 5 minutes for around 20 sec and...

biju george

01-21-2004 07:04 AM
Tom Moreau

Hello, I currently administer a two node active active cluster running Window NT 4.0 Server with SQL Server 7.0. Can anyone please explain to me...

eaiden

01-20-2004 04:02 PM
Rand Boyd [MSFT]

I had the error below and could not find a solution. Called Microsoft and obtained a solution. I am posting as an FYI to others than may encounter...

Jay Griffin

01-20-2004 01:05 PM
Jay Griffin

I have setup Log Shipping and all is well. Next, I have tried to switch the roles of the Primary and Secondray roles (using sp_change_primary_role,...

Daniel Hope

01-20-2004 10:21 AM
Daniel Hope

I´m trying to install a MS Cluster with two IBM x370 machines and Storage Server IBM FAStT200 Fibre Channel. The cluster installation procedure...

Guillermo Gonzalez

01-19-2004 06:12 PM
Guillermo Gonzalez

My company are planning a SQL cluster in Active\Passive mode. In a similiar vain to the earlier post regarding Active\Active - what should be my...

Jof

01-19-2004 05:03 PM
Jof

I have a W2K3 cluster with the High Security Template installed. When I try to install SQL 2000 on the first node of the cluster, the setup fails...

Kevin

01-19-2004 03:01 PM
Ray S \(MSFT\)

How do I move a database from a non-clustered sql server to a clustered sql server and be able to use the database.

Robert Wishart

01-17-2004 09:01 AM
ross

I got two hard disks (36GB each) on each of two SQL Servers and one Storage Area Network (SAN) as 73GB x 8. We would like to install SQL Cluster in...

Po-Shan Chang

01-17-2004 08:51 AM
ross

Hi Guys, My sql 2000 active/passive cluster on win 2k failed over automatically to the second node and i can see following error in the event log...

biju george

01-17-2004 03:56 AM
biju george

Can anyone send me a snap shot of what the HKLM\Cluster registry key looks like? I need a point of reference TIA Jenn

Jenn

01-16-2004 03:41 PM
Jenn

I am planning on installing SP3 on SQL2000 with SP2. The SQL server is clustered and I am wondering if I am going to encounter any problems? I read...

Zaid

01-16-2004 09:19 AM
Chandrasekar Gopalan

Is there any comparision whitepaper to describe to use a/a mode or a/p mode for SQL Cluster I was told that Microsoft suggested to use a/p mode, so...

Po-Shan Chang

01-15-2004 05:08 PM
Linchi Shea

I need to be able to detect (during the installation of my application) if a machine that is part of a cluster is running version 7 of SQL server. ...

jam95670

01-15-2004 01:16 PM
jenn

There is a large amount of debate going on in our IT group about whether to go with Active/Active or Active/Passive. We are running several...

Mike Johnson

01-15-2004 11:16 AM
Ken Proctor

How load balancing feature is enabled with SQL 2000 clustering service.

Sunil Dash

01-15-2004 07:38 AM
Andrew J. Kelly

OK, after several trial installations and reading many white papers and newsgroup posts, I have become completely confused on the proper use of...

Michael [multnomah]

01-15-2004 02:06 AM
Tomer Meshorer

The resource fails to come online. The server is W2003 Enterprise SQL is 2000 Ent. After the cluster is up and running I installed SQL server as...

Nico

01-14-2004 06:36 PM
Amit Kumar [MSFT]

Hello, How do I set the SQL Server Agent and Fulltext Services to Autostart within our SQL Server 2000/Windows 2003 EE Server environment? In...

Michael [multnomah]

01-14-2004 04:51 PM
Jinhe

Hi GUYS, i can see these errors in sql error logs . are they serious? what action should be taken. pls advice me . SQL Server Assertion:...

biju george

01-14-2004 04:10 PM
Geoff N. Hiten

Hi, I have a set of 4 servers coming in to be installed as a cluster running Win 2003 Enterprise with SQL2000, all to be connected through Fibre...

Benny Koh

01-14-2004 04:04 PM
Geoff N. Hiten

Currently have 2 clusters for sql server 2000 enterprose edition with one being my primary database server and another at a DR site. Is there any...

tom frost

01-14-2004 12:25 PM
tom frost

I have done the setup of SQL Virtual server Cluster setup with one named instance with database and log file locations on the same drive over shared...

vivek_dalvi@ashinfo.com

01-14-2004 09:17 AM
Darren Green

Hello, Wondering if anyone can assist with this problem. We have SQL 2000 clustered over two servers. SQL runs fine when on server 01, but when we...

Steve

01-14-2004 08:08 AM
Steve

No, it does not apply to Win2K Cluster. The information in 327270 applies to Microsoft SQL Server 2000 (all editions), when used with the operating...

Uttam Parui[MS]

01-13-2004 06:59 PM
Uttam Parui[MS]

I have a two node Active/Passive SQL cluster. I need to know how I can bind two IP addresses to the SAME vitual SQL cluster name. I need to add my...

SQL Newbie

01-13-2004 06:56 PM
Uttam Parui[MS]

Hi, Someone upgraded MDAC on two clusterd IIS servers about a month ago. Now when I open Application Manager and try to view events, I no longer...

Ishmeal

01-13-2004 04:46 PM
Ishmeal

Hi I'm using SQL 2000 Enterprise Edition with 2 Windows 2000 Advanced Server nodes (active/ passive cluster) with shared disks We are having some...

Jeroen Hoogervorst

01-13-2004 04:46 PM
Linchi Shea

you can manually check folders, binaries and registry entries on new node to see if there are apparent problems. use cluadmin to check if the new...

Jinhe

01-13-2004 10:25 AM
Rand Boyd [MS]

At our center we were under the impression that with a sql cluster system the app would be up if a node failed and rolled to second node. My...

CD

01-13-2004 10:20 AM
Rand Boyd [MS]

I had initial had one server and set up the Windows 2000 server cluster (A) with SQL Server 2000. After several months I received the other Windows...

Dean

01-13-2004 09:39 AM
Geoff N. Hiten

hi we have a 2 node cluster everything is working fine except for backup maintainance plan backup fails randomly for user database with error 3041...

gubba

01-13-2004 03:49 AM
AZ

How do I display the Windows 2000 Advanced Server Cluster logs? Where are the cluster installations logs stored? Thank You, Fred

Fred

01-12-2004 08:21 PM
Jinhe

I am trying to install a cluster of two computers. Both of them are going to be production machines which have similar applications installed on it....

Shailesh

01-12-2004 11:35 AM
Linchi Shea

I would run DBCC checktable to see if there are any corruption related errors on this table. Rand This posting is provided "as is" with no...

Rand Boyd [MS]

01-11-2004 11:13 PM
biju george

Does anyone know how to reset or resync the Log Shipping Transaction on the Standby Server? I am in testing mode and ran a backup log dbname with...

William Enloe

01-11-2004 04:02 AM
Ron Talmage

Hi. I want to setup a federated database servers for a production environment. What i already have are 4X dual cpu machines (each machine equipped 4...

01-09-2004 11:48 AM
Allan Hirt

I recently change the account that sql server runs under. Now I reinstalled the MS Outlook for the new account and configured the exchange server and...

Ash

01-09-2004 03:56 AM
Sankar Renganathan

I am new to trying to run a cluster. I need to know if I can cluster Exchange 2000 along with SQL 2000 such that they both run on an active box with...

Coll Campbell

01-09-2004 12:11 AM
Uttam Parui[MS]