Two questions please 1. Is it true that during role change sometimes the scripts fail with no apparent reason and sometimes they work? In other...

John C.

02-22-2004 08:11 PM
John C.

Hi everyone, I have a Design Question about clustering SQL. I know clustering is an expensive solution but I was given a project to provide high...

David V. Dellanno

02-22-2004 06:20 PM
David V. Dellanno

This is the error SQLSTP log file from the active node to the passive node which has already joined the cluster. The unattended install failed to...

sql2knode2

02-22-2004 03:14 PM
Martin Ha

Hi! Can anyone tell me, if someone has experience with MS Cluster in conjunction with SAMBA as PDC??? Thx you for your help!

Martin Ha

02-22-2004 03:05 PM
Martin Ha

Hi all We are planning to set up the following Cluster design 4 nodes running 2003 EE and SQL 2000 EE. 2 active nodes and 2 passive for fail over....

nexus99

02-20-2004 08:28 PM
Geoff N. Hiten

Hi, I have a 4 Gb RAM , 2 Xeon processors machine running SQL Server 2000. I have a large number of records and it seems to be collapsed. I would...

02-20-2004 10:59 AM
Andrew J. Kelly

Setting up a 2 node cluster with SQL 2K on Win2k3. How many servernames/clusternames(virtual servernames) do I need ? Upon setting up with windows...

Hassan

02-20-2004 04:36 AM
Shirley Kelly [MS]

Hi All I'm struggling to find some good documentation on how to place SQL ersources in the cluster groups. Wuold I be correct in saying the...

J

02-20-2004 01:53 AM
Bjornmob

I have a two-node SQL2k active/passive failover cluster on WIN2k ADV SP3. I would like to install a new instance of SQL2k for another application in...

Olutimi

02-19-2004 11:14 PM
Shirley Kelly [MS]

Hi am looking how many nodes SQL Server is supporting with Windows 2003 depending of the version : 1. Windows 2003 Enterprise with SQL Server...

Pierre Destrée

02-19-2004 05:21 PM
Stephen Strong

{Lost Delayed-Write Data} The system was attempting to transfer file data from buffers to \Device\HarddiskVolume2. The write operation failed,...

Teri

02-19-2004 04:31 PM
Doug Guerena

Should I run my transaction log on Raid 1 or Raid 5? How about the data file Right now I have them both running on Raid 5 Thanks for the help.

Eric Ward

02-19-2004 12:31 PM
Geoff N.Hiten

Hello to all At this time I have problems in configuring a cluster in windows 2003 64 bits it has server itanium, with an external storage Eva3000 ...

Ana Maria

02-18-2004 08:06 PM
Gianluca Hotz

We are going to implement Cluster Server on Win 2003 SQL 2000 SP3 Application is web based and there are some batch process . Need clarification on...

M A Srinivas

02-18-2004 07:25 PM
Chandrasekar Gopalan

I received the Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace (OLE/DB Provider 'MSDAORA' IDBInitialize. I received the...

Dan

02-18-2004 03:59 PM
Dan

We are planning a new project where we'd like to ghost images of the O/S and several applications including SQL Server on a 2-node Windows Server...

Cathy

02-18-2004 10:24 AM
Cathy

We would like to setup a two node cluster using windows server 2003. We do NOT have a shared, block-level disk device to use for the quorum disk....

Robert

02-18-2004 07:58 AM
Gianluca Hotz

now I had a cluster ,want to add mssearch serive to the cluster,because our sqlserver need to use fulltext,but when I add it to the cluster,the...

yuhong wu

02-18-2004 04:36 AM
yuhong wu

We're in the process of building new servers. One would be Win2k Advanced, Cluster Service, and SQL 2k Enteprise. The question I have is what's the...

Samm

02-18-2004 02:56 AM
Luca Bianchi

I having some difficulties uninstalling SQL2000 from win2003 clustering system. The uninstall option from setup procedure is unavailable(shadowed). I...

Nir

02-17-2004 11:14 AM
Nir

I have loaded the Oracle client on a development server and set up a linked server for testing. But I need to set this up in a production...

Mike

02-17-2004 10:07 AM
Mike

Future Environment: Cluster of 2 node IBM x445 4 CPU 2.0 GHZ 4GB Memory each server. 1 Controller IBM FastT700 with 2 EXP700. 26 FC-HDD 74GB 15K in...

franco

02-17-2004 09:30 AM
Rand Boyd [MSFT]

I having some difficulties uninstalling SQL2000 from win2003 clustering system. The uninstall option from setup procedure is unavailable(shadowed). I...

Microsoft

02-17-2004 01:38 AM
Microsoft

Hi, I am planning to install two nodes clustered sql server, should I install domain contraoller in both nodes with one is PDC and another is BDC?or...

Li

02-17-2004 12:16 AM
Stephen Strong

This is a Windows 2000 Advanced Server that is clustered with SQL Server 2000 with SP3A. This is a Active/Active Cluster setup with a A and B...

Mike

02-16-2004 11:41 PM
Stephen Strong

Hello all. We've just built a Windows 2003 EE active/active cluster. SQL Server 2000 is installed on each node. MSDTC was installed after-the-fact...

David Pendleton

02-16-2004 11:36 PM
Stephen Strong

I’m looking for a consultant who has experience with MS SQL Server in a web farm environment. The person must have experience with the...

Eric Ward

02-16-2004 11:06 PM
Eric Ward

Hi everyone, As of today, we are unable to connect to the SQL Server connection with Enterprise Manager. The operation fails with the following...

Eric Caron

02-16-2004 04:31 PM
Doug Guerena

Why do we use a cross over cable and not a straight cable for the private n/w of a cluster? What is the difference between the 2 ?

Hassan

02-16-2004 11:08 AM
Geoff N.Hiten

Tom, Affinity mask is also set to use all procs. Any other thoughts?

Chad

02-16-2004 09:12 AM
Tom Moreau

We had a hard disk fail which caused our SQL 2000 database to turn gray and say 'Suspect'. I detached the database and tried to reattach it. I get...

Eric Ward

02-16-2004 09:01 AM
Eric Ward

Whats the minimum no. of IP addresses I need to setup a SQL Server 2000 cluster and where do I need to use them ? Need to grab some from my...

Hassan

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

Do we need MSDTC for clustering ? Using SQL 2000

Hassan

02-15-2004 03:56 AM
Shirley Kelly [MS]

What scenarios would result in bringing the cluster down/offline ? I mean.. in situations when you apply OS service packs/security patches or SQL...

Hassan

02-15-2004 03:53 AM
Shirley Kelly [MS]

We have 2 IBM xSeries 360 servers with 4 processors and 8 GB of ram in each. These machines are setup in a clustered environment. Originally, these...

Chad

02-13-2004 05:41 PM
Olu Adedeji

This is configured to use all processors. Do you have any other ideas what could be causing our problmes? Currently, we have hyperthreading turned...

Chad

02-13-2004 03:51 PM
Tom Moreau

I am trying to move my pubs and northwind log files to a different shared disk on a clustered system (because I have data and logs separated). I am...

TechGirl

02-13-2004 02:09 PM
Cindy Gross

Hello, I have sucessfully setup a 2 node win2003 cluster w/ sql2000. I can move all sql resources to node 2 just fine when node 1 remains up and...

Phil

02-13-2004 02:06 PM
Cindy Gross

Hi guys: I would like to acquire a little hands on building a clustering environment. As per my initial readings, this is what I would need, could...

White Jul

02-13-2004 01:05 AM
WhiteJul

I need to add MSDTC service to an already running Windows 2000 ADV server cluster (SP4) w/dual instances of SQL server installed. There are 3...

ml.net

02-12-2004 10:18 PM
Jim Carley

Hi, We are currently having issues with SQL Server 7.0 (sp3) running on windows NT4.0 active/active cluster...The error that we are getting...

Karthik

02-12-2004 01:02 PM
Karthik

Hi , We are having an issue with SQL Server 7.0 (sp3) which is running on Windows NT 40 on a cluster (Active/Passive)..The message we get is Error:...

Karthik

02-12-2004 11:39 AM
Karthik

Hi Guys, my sql server 2000 running in active/passive cluster mode. right now i have ony one raid array on which i placed datafile and logfile. now i...

biju george

02-12-2004 01:43 AM
Allan Hirt

Expanding virtual disks presented to a MCS cluster on W2K from a SAN works well - simply increase the virtual disk on the SAN then use diskpart (not...

Stephen Strong

02-12-2004 01:41 AM
Allan Hirt

Hi I'm currently setting up a SQL Server 2000. My configuration is: Instance MyCompany running on ServerA Instance TheirCompany running on...

Simon Niederberger

02-11-2004 03:14 PM
Geoff N.Hiten

Hi al I have a scenary SO Windows 2003 Enterprise edition 64 bits, I built a cluster on two nodes ... than install SQl Server 64 bits i beginning to...

Anita

02-11-2004 01:26 PM
Chandrasekar Gopalan

Win2K SP4 with SQL2K SP4. Have noticed that some of our users home directories are not accessible when failed over to node A? Both from the user...

Todd Paulson

02-11-2004 12:21 PM
Allan Hirt

I have two servers, one server was set up with Windows 2000 Advanced Server that was clustered as a stand-alone and installed SQL Server 2000...

Dan

02-11-2004 08:58 AM
Allan Hirt

Take a look at the sqlstp.log in the windows directory on all nodes. Also, are you running the setup (which performs a remote setup on all nodes)...

Stephen Strong

02-11-2004 01:36 AM
Stephen Strong

Hi guys, I must move my cluster SQL 2000 from EMC-SAN to another SAN. Is there a Tech doc that describe how I can do It ? (move quorum, move...

Mirko

02-11-2004 01:11 AM
Stephen Strong