I've read the post/replies explaining how to setup MSDTC on a Windows 2003 server which is definitely great information. At this point, I still...

Travis Butynski

05-06-2004 10:19 AM
Michael Hotek

Hi all I'm looking for step guide to set up SQL 2000 with W2K3. I could only find SQL2000 with Windows 2000 Thanks Cheers Kok-Mun, Ho

Kok-Mun, Ho

05-05-2004 11:01 PM
Kok-Mun, Ho

We have SQL Database in Cluster volume F: Cluster volume is mounted in the primary server A1. We have production and test databases of the...

Anonymous

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

I have a two node SQL Server 2000 cluster running on Windows 2000 Advanced Server. It's an Active/Passive configuration. Now we will be replacing the...

Asim Mian

05-05-2004 03:32 PM
Loay Shbeilat [MS]

Hi, We currently have a two node sql cluster running SQL Mail. At present we have to manually start up outlook so the mail client works. I have...

Adam Maltby

05-05-2004 09:52 AM
Adam Maltby

Hello I need to update a clustered win2k os. The service pack applied on this clustered server was sp3 a server build time. I've applied the SLQ sp3...

Joe48184

05-03-2004 01:44 PM
Rodney R. Fournier [MVP]

How much work is it to add spindals to a drive on a Windows 2000 Advanced Server clustered on a SAN? Thank You, Dave

Dave

05-03-2004 01:26 AM
Stephen Strong

I should take offline backup at midnight after stopping our sql server 2000. But it's prohibited to stop by writing a task like "net stop...

aculfa

04-30-2004 06:46 PM
Sandeep Sutari [MSFT]

I have a couple of questions now that I installed a multi instance SQL 2K failover cluster on Win2003 . In my case 2 instances 1) How does one apply...

Hassan

04-30-2004 04:36 PM
Michael Hotek

Not in the current version of SQL Server. However, database mirroring in Yukon may be of interest to you. Have a look...

Geoff N. Hiten

04-30-2004 10:33 AM
Geoff N. Hiten

Hi. In general terms, what would be the steps to have my SQL2000 (on W2K OS) 2 node-clusters join a new domain? They are member servers...

Bonehead

04-30-2004 09:56 AM
Rand Boyd [MSFT]

That's because the password for the SQL Server service account does not match the Windows password. -- Mike Principal Mentor Solid Quality...

Michael Hotek

04-30-2004 09:53 AM
Rand Boyd [MSFT]

Windows updates do not affect the ability to restore a back up. Open up Query Analyzer and explicitly type in the command string to restore...

Jim Trowbridge

04-29-2004 04:07 PM
Michael Hotek

following up on the geerhead message: first, uncluster the SQL then reboot node1 second, upg the sql 7 to sql 2000 third, upg the sql 2k to sql...

wadeing in vain

04-29-2004 04:05 PM
Michael Hotek

From BOL "When MS DTC is running in clustered mode, only one node in the cluster runs the MS DTC transaction manager at a time." So if i have setup...

Hassan

04-29-2004 12:47 PM
Hans de Bruin

Is their any document avaiable on Active-Active SQL cluster on microsoft site. If yes can some one please send the link

Harsha

04-29-2004 09:28 AM
Michael Hotek

Should a distribution be backup? Thank You, Mike

Mike

04-29-2004 09:25 AM
Michael Hotek

If I offline one of two nodes in a cluster, can I add an internal drive to the offlined-node, then bring the node back online into the cluster? Will...

Eric Cross

04-28-2004 08:14 PM
Van Thothathri

Folks, My question is what should the SQL service and SQL agent service be set at. Should it be set to start automatically or manually? Thanks, B

Bob

04-28-2004 02:16 PM
Rand Boyd [MSFT]

A slight confusion. I have created a windows cluster with 2 nodes and a single instance of SQL 2K cluster Is it possible to create many windows...

Hassan

04-28-2004 01:21 PM
John Toner [MVP]

I run the DBCC for a database in Query Analyzer, and it takes 3 minutes. I take the same SQL script and place it in a job through Enterprise...

Canaries

04-28-2004 09:41 AM
Canaries

I am trying to install an Active/passive cluster of SQL 2000 on a Win2003 machine. Can any one give me details stapes how to configure it same and...

Sameer Prabhune

04-28-2004 01:01 AM
Sameer

Consider the following scenario: I got 2 webservers (2003) using NLB. I want some kind of common data store (SQL Server). I need this data store to...

Johan

04-27-2004 10:59 PM
Michael Hotek

Hi Guys, i am planning to implement logshipping in sql 2000 which is already a pulisher for transactional replication. i am planning to take...

biju george

04-27-2004 10:51 PM
Stephen Strong

We are running a SQL within an Active Active Windows Cluster setup. Will I run into any issues when attempting to patch SQL with SQL SP3? Are there...

04-27-2004 10:42 PM
Michael Hotek

Dear all, Does anyone know if the next version of SQL will support load-balancing as well as fail-over clustering? Thanks. Regards, Kueh.

KA Kueh

04-27-2004 10:40 PM
Michael Hotek

Dont know clusters, just starting to look into them. I do, however, have needs for fault tolarance. Starting with our email server. Sounds to...

IFreyre

04-27-2004 10:35 PM
Michael Hotek

You need to use Unicode datatypes such as nchar and nvarchar. After that, the data should store in SQL Server without any problems. But, I've...

Michael Hotek

04-27-2004 10:30 PM
Michael Hotek

I decided to try and setup a multi instance cluster on my own and seem to be fairly successful . Its SQL 2000 EE on Windows Server 2003 EE Just had...

Ronald

04-27-2004 07:46 PM
Geoff N. Hiten

It Depends. The initial service pack or hotfix installation should be done at the node that owns the resource. This will update all binaries and...

Colemont Bert

04-27-2004 01:07 PM
Geoff N. Hiten

We are working with a Windows Server 2003/SQL 2000 cluster. We have split our SAN volumes into three separate drives. From Enterprise Manager, we...

Theo Jones

04-26-2004 02:17 PM
Theo Jones

Do any guidelines exist? Situation: Active passive 2 node cluster using SAN drive. For starters I'm thinking: 1. back up all SQL databases located...

Michael Trantow

04-25-2004 12:48 PM
Cindy Gross

Situation: Two nodes, two nodes are active, two virtual servers, two separate applications. One active and one wait on each. Active on each fails...

Lucian

04-25-2004 12:44 PM
Cindy Gross

How do you install SQL server in Active/Active cluster? We want have an instance of SQL running on each of two nodes. What different when...

John Wang

04-25-2004 10:36 AM
Geoff N. Hiten

I am setting up an Active/Active cluster with one instance of SQL in each node. When I am failing over from one node to the other, the SQL Server,...

Dylin Mikals

04-25-2004 10:33 AM
Geoff N. Hiten

I have a need to unistall cluster services. This is on a Win2ksp4 server with Sqlserver2ksp3. Currently only one side of the cluster is setup....

John Hubbard

04-25-2004 10:21 AM
Geoff N. Hiten

I will be relocating a SQL 2000 cluster onto a new subnet of a corporate network and will need to change the 'public' IP address of the cluster nodes...

DBADave

04-23-2004 05:39 PM
mattkoo

I've read in clustering articles that mount points are not supported. I've also read that they are. Which is it Has anyone implemented them in a...

NYCTECHGIRL

04-23-2004 04:40 AM
Bjornmob

Hi SQL folks, We had a database just disappear. It shows up in Enterprise Manager, but the MDB and LDB files are just gone. All the other...

Nick White

04-22-2004 07:48 PM
Cindy Gross

Hello Articleno: 269196 and 319016 are describing how to move cluster servers to a new domain and changing domain for a SQL2000 failover cluster My...

Johnny Lundgren

04-22-2004 07:44 PM
Cindy Gross

I keep receiving the warning message in the event viewer that the Eventlog replication queue is full. Error: EventLog replication queue OUTQ is...

Dan

04-22-2004 07:40 PM
Cindy Gross

I have: -nt 4 enterprise w/ sp6a -MSCS Active/Passive -sql 7.x enterprise w/ sp3 I want to upg the SQL 7 to SQL 2000. Do I: -Upgrade server 1 to...

geerhead

04-22-2004 12:54 PM
geerhead

Sorry, this on may be a very easy question for this group but I've to find the right answer until weekend.. : )) I should take offline backup at...

aculfa

04-22-2004 04:22 AM
aculfa

Please look at the section on SANs: http://support.microsoft.com/default.aspx?scid=kb;en-us;254321 Cheers, Rod "Ionel" <ionel_catanoiu (AT)...

Rodney R. Fournier [MVP]

04-20-2004 04:22 PM
Rodney R. Fournier [MVP]

Hi I have a two node cluster with SQL2000 SP3. When the node1 fails over to node2, the SQL Server Agent fails. The log file says "Login Failed for...

Marc

04-20-2004 04:21 PM
Marc

I have a 2 node cluster on which I am trying to install a virtual SQL Server. I am able to complete the setup process, but the installation fails...

Simon Call

04-20-2004 10:54 AM
Rand Boyd [MSFT]

Hi! This is the scenario: * Windows 2000 Advanced Server clustered with 2 nodes After the installation of SQLServer in the first node, does not...

Ren?

04-20-2004 04:27 AM
Ren?

Can anyone provide help regarding recbase.cpp , record.inl assertion error New cluster system, W2K3 Datacenter, SQL2000+SP3a, IBM x445 Two-way SMP...

MacManaman

04-19-2004 10:16 AM
war_friends

i got active\active clustering environment when i went to clustering administrator i see in cluster groups the 2 nodes are having red x mark what...

Man

04-19-2004 04:05 AM
Bjornmob

Hello, I am purchasing a HP DL-380 (Cluster) I am planing to install Windows 2003 and SQL 2000 Both machines has two processors and 4 GB o Physical...

AA

04-17-2004 04:17 AM
Michael Hotek