I would like some advise on my plan to install an active/active sql cluster. The plan is to build 2 boxes with W2k3 server and SQL2003. I'll have...

Wayne

10-25-2004 05:00 PM
Rodney R. Fournier [MVP]

Hi, I have two identical servers. I want to put Win 2003 Enterprise and SQL Server Enterprise on both of them. The data will be written to and read...

Jason Robertson

10-25-2004 10:05 AM
Sinisa Perovic

Hi I need to move the transaction logs for all the sql db's (including master, model and user db's etc) to a seperate drive. Does anyone have any...

Parky

10-25-2004 07:51 AM
Luca Bianchi

Hi everyone, We have a Windows 2003 Server NLB Cluster getting data from Windows 2003 Server SQL Cluster. Occasionally we get Connection Timeout...

news.microsoft.com

10-25-2004 03:35 AM
Michael Cheng [MSFT]

I am getting the following error. 00000a94.00000fb4::2004/02/29-05:22:25.943 Microsoft Search Service Instance <SQL Server Fulltext>: An error...

Jason Massie

10-25-2004 01:30 AM
R J

I am looking for the Microsoft instruction to install SQL Server 2000 on Cluster with Windows 2003 Server operating system. I start the uninstall...

Joe K.

10-23-2004 01:17 AM
Joe K.

We want to set up another office as an online disaster recovery site. Can I clister between two SQL servers over a T1?

Rick Vines

10-22-2004 06:29 PM
Rodney R. Fournier [MVP]

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services...

Jason Robertson

10-22-2004 05:49 PM
Jason Robertson

Hi, I am presently running Windows 2003 cluster with SQL Server 2000. My question is what is the correct way to apply Critical Updates to a...

Bob Mare

10-21-2004 08:58 PM
Greg D. Moore \(Strider\)

Look at How to configure memory for more than 2 GB in SQL Server http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&Product=sql2k And...

Harbhajan

10-21-2004 09:14 AM
Geoff N. Hiten

I have W2KAS, SQL Server 2000 active/passive cluster with cluster MSDTC resources. I use NT Task to execute DTS package via DTSRUN and package...

Michael Leung Kim Ming

10-21-2004 03:32 AM
Michael Leung Kim Ming

Hi, We have one cluster with 2 virtual databases and name instances VDB01\DB1 and VDB02\DB2. They use different storage on a SAN. Machines are...

C.Dimitrov

10-20-2004 02:01 PM
C.Dimitrov

Where can I find a complete step-by-step article on installing SQL 2000 Enterprise Edt. in a Windows 2003 Enterprise Edt.Cluster? We have purchased...

Derek

10-20-2004 09:38 AM
Geoff N. Hiten

Hi, Could someone please explain to me in an idiots guide kind of way!!! How Active Active clustering works when the underlying Windows 2003...

Jody Stoll

10-20-2004 09:25 AM
Geoff N. Hiten

Hi, In MS Clustering the failover happens only at hardware level or it can also happen at application level? I mean If I am running two nodes,...

Reddi

10-20-2004 02:39 AM
Reddi

Is there a reason why the SQL 2000 installer would not be running on 2003 Web edition?

Ed

10-20-2004 02:06 AM
Greg D. Moore \(Strider\)

Hi there, I have a two node cluster Win 2k with SP4 and SQL 2k with SP3. There are two instances of SQL. The primary instance comes up just fine. ...

Squerb

10-20-2004 01:39 AM
Mike Epprecht (SQL MVP)

We have two active clustered sql servers and two separate IIS Load balanced servers. We can connect to both instances of sql server Enterprise...

tplumley

10-19-2004 02:37 PM
C.Dimitrov

Hi! We are planning to replace our disk system in our SQL Server cluster environment. Our system consist of two cluster nodes and two SQL Server...

Mikko Rantonen

10-19-2004 09:38 AM
Geoff N. Hiten

How does one use the SQL virtual device interface (vdi) in a SQL Server cluster? The VDI connection command only accepts a parameter for...

Ray Mond

10-19-2004 12:47 AM
Ray Mond

Hi, I'm trying to install a 2nd instance on a cluster. We've setup two cluster groups C101TC001 and C101TC002, one for each instance. I've stopped...

Beverley

10-18-2004 11:53 PM
Uttam Parui[MS]

I have a Windows 2000 Advanced Server with SQL Server 2000 Cluster. There are only two nodes on this cluster. Two days ago I tried to move one of...

Joe K.

10-18-2004 02:50 PM
Mike Epprecht \(SQL MVP\)

I'm not able to start the cluster service on the 2nd node of our cluster. O/S is 2003, with SQL 2000. The 2nd node is passive, and appears to join...

Chris

10-17-2004 09:19 AM
Greg D. Moore \(Strider\)

Hello, I have an A/P W2K3 Cluster with SQL 2K-SP3. When I fail it over to the passive node, only the virtual server name is available, not the SQL...

tbithoney

10-14-2004 11:19 PM
Uttam Parui[MS]

Everyone, I'm installing SQL Server 2000 SP2 virtual server onto a Windows 2003 Cluster. The install process seems to install sql server fine on...

Shannon T.

10-14-2004 08:43 PM
Shannon T.

I'm doing an investigation into moving our database server to a database cluster. One of the questions I haven't been able to answer is how...

Brian Richards

10-14-2004 12:28 PM
Stephen Dybing [MSFT]

We have 2 SQL clusters where the SQL Server cluster resource fails but if you go to the SQL Manager, you can start the service and query the DB. Has...

Roniva Brown

10-14-2004 12:10 PM
John Gose [MS]

Hi, How can i upgrade sql 2000 64bit local default instance to clustered instance? i can't find "Upgrade your existing installation to a...

Petri

10-14-2004 10:45 AM
Mike Epprecht (SQL MVP)

Proliant DL360 G3 w/hyper threading 2 physical CPU, 2 gigs of memory MSA 1000 Windows 2003 SQL 2000 SP3a

Tim

10-14-2004 07:56 AM
Mingqing Cheng [MSFT]

We just build our first 2 nodes cluster on Windows 2003 / SQL2000 SP3a + HF 818. Does anybody knows if there is any other HF need to be applied on...

Ayad

10-13-2004 05:13 PM
Geoff N. Hiten

We needed to change the drive path for one of our SQL Server Instances. All system databases have been changed, but we are having trouble changing...

michael [multnomah]

10-13-2004 05:39 AM
Shashank Pawar [MSFT]

I'm aware of KB article 239885 about how to channge SQL accounts on a SQL virtual server. However, is there an easier way to ensure the account has...

Scott Matthews

10-13-2004 02:06 AM
Uttam Parui[MS]

Are there any 'gotchas' that one needs to consider before running this on a single node - anything different than a stand-alone...

Darryl Pollock

10-13-2004 01:16 AM
Uttam Parui[MS]

Ken, As such one does not have to move the SQL Server resources to the new node where you want to install SQL SP. If you want to troubleshoot and...

Ken Jensen

10-13-2004 01:13 AM
Uttam Parui[MS]

Is it possible to change the current SQL virtual host name in Windows 2003? and How? I tried it by right click on the SQL Network name resource ->...

Ayad

10-13-2004 01:08 AM
Uttam Parui[MS]

Hi all gurus I am having a strange problem. I am having a cluster box win 2000 Advance server running Sql server in Active/Passive mode. Currently we...

Nik

10-12-2004 03:45 PM
unoit@bellsouth.net

Hi, I'm currently looking in the possiblities for a SQL server install. The web project needs a SQL database with a high availability. Speed and...

christophe

10-12-2004 08:52 AM
Hilary Cotter

I need to change all of the ip's on my two node cluster including the nic cards and all of the virtual devices. What i am asking what is the best way...

Jim

10-11-2004 10:33 AM
Geoff N. Hiten

hello everyone, i tried this question in olap room but there was no reply. i had a question regarding Expectation-Maximization algorithm used by...

10-10-2004 09:45 PM
Hilary Cotter

I have MS SQL 2000 Server SP3 cluster in active/active mode, windows 2003 with 4GB of RAM and 2 Intel Zeon CPU of 2.80 Ghz. In the SQL Server Logs...

David

10-09-2004 10:50 PM
Hilary Cotter

Hello I'm about to install a active/active sql cluster on windows 2003 server. I've installed the cluster service without any problems. My question...

10-08-2004 03:49 AM
Franco Conenna [MSFT]

Sure...

cgunner

10-07-2004 01:52 PM
Rodney R. Fournier [MVP]

Hi, Sometimes, in my application, when i browse a record, it takes very fast 1/2 seconds but sometimes it seems like hang there and take a very long...

florencelee

10-07-2004 07:50 AM
Hilary Cotter

Hi, Sometimes, in my application, when i browse a record, it takes very fast 1/2 seconds but sometimes it seems like hang there and take a very long...

florencelee

10-07-2004 05:25 AM
Mike Epprecht (SQL MVP)

hi everyone, i had a question regarding Expectation-Maximization algorithm used by microsoft for data mining in ole db. Does anyone know how good...

praveen konda

10-07-2004 05:23 AM
Mike Epprecht (SQL MVP)

Hi, on a two node cluster, Do I need two seperate SAN boxes If i have to run SQL Servers on a Active/Active clustering?. Regards Chip

Chip

10-07-2004 02:06 AM
Chip

Hi all I have just installed a SQL2000 cluster on Win2000. The last thing I did was install sp3a from Node A (both Nodes were online) Checked the...

Darryl Pollock

10-07-2004 12:20 AM
Darryl Pollock

It actually turns out an issue found in: http://support.microsoft.com/default.aspx?scid=kb;en- us;815431&Product=sql2k This fixed the...

Jim

10-06-2004 02:33 PM
Jim

Very new to Windows2000/SQL2000 Clustering, recently set up an Active/Passive 2 node SQL Cluster. Unfortunately one of the Collation settings needs...

Dazza

10-06-2004 11:05 AM
francoc[MS]

Hi all, From what I've read, dynamic disks are not supported as shared drives when using a Windows 2003 cluster, only basic disks. What happens...

Alec Waters

10-06-2004 10:20 AM
Geoff N. Hiten