Am I right in saying that you can't implement a failover SQL Server 2000 cluster using NAS? Ie - you have to be using direct attached storage...

Ken Shaw

04-17-2004 04:13 AM
Michael Hotek

Michael, One thing that is different between the two environments are the privileges. For instance, you may have a mapped drive accessible to you in...

Nobody

04-16-2004 05:27 PM
Nobody

I have been working as SQL server DBA on standalone servers for about 3 years. I have been using SQL Server 2K Personal Ed. on my pc to do most...

Ron Michaels

04-16-2004 04:11 AM
Sinisa Perovic

I am planning on a two node cluster with multiple instances. I will have two databases and two separate applications will be going against them. I...

Earl Spooner

04-15-2004 04:17 PM
Rodney R. Fournier [MVP]

Does the MSDN subscription allow me to set up an active/passive cluster for test/dev ? TIA

J O Holloway

04-15-2004 04:14 PM
Rodney R. Fournier [MVP]

Hello All I am having trouble of DTC to get working thru firewall The setup we have is Two web servers load balanced. Componets run off the web...

Mils

04-15-2004 10:46 AM
Mils

Yes you can do this. I would look at the following articles for more information: HOW TO: Move Databases Between Computers That Are Running SQL...

Rand Boyd [MSFT]

04-15-2004 09:47 AM
Rand Boyd [MSFT]

Hello gurus! I know that SQL 2000 and very probably Yukon SQL do not support a shared disk cluster. So, in the shared nothing schema is possible to...

AA

04-14-2004 10:50 AM
Geoff N. Hiten

I am having trouble connecting when using the IP address to a named instanced using dynamic port assignments and hosted on a 2K3 cluster (even when...

MCDBA Wannabe

04-14-2004 09:50 AM
MCDBA Wannabe

We are installing a Active/Passive cluster for our servers. We want to make sure that we don't go down. We are looking at installing an SQL cluster,...

M.Siler

04-14-2004 02:07 AM
Michael Hotek

in clustering groups i got two nodes node 1 is howing failed and node2 is showing partially online what does it mean but resources shows online

Man

04-14-2004 02:02 AM
Michael Hotek

Hi, if I have a cluster of servers ( 2 to be exact), do I need one copy of sql server or one for each server ? Thanks

Raj

04-14-2004 02:01 AM
Michael Hotek

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

AA

04-14-2004 01:59 AM
Michael Hotek

does anybody aware of any issues when installing SQL2K in NT4 domain? Help is greatly appreciated.

igor_gonik@dell.com

04-13-2004 02:23 PM
Rand Boyd [MSFT]

If you can count the cost of downtime then, depending on these costs to business, you may be able to justify to management the cost of moving to W2K...

Stephen Strong

04-13-2004 10:25 AM
Sanchan Sahai Saxena

HI GROUP I have my production sql server computer name "sql2k" and of course the default sql instant name as "sql2k" because they're running on same...

Frank

04-13-2004 02:27 AM
Michael Hotek

We have installed sql server 2k on windows 2003. We are having problems with the MSDTC working correctly. We cannot get this service to fail over....

ash@discussions.microsoft.com

04-12-2004 10:50 PM
Hassan

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-12-2004 04:53 PM
AA

Hi All~ Now that we have taken the big step to a clustered SQL enviroment we are ahving problems deploying some hotfixes and patches to the cluster....

Joe Huffman

04-12-2004 02:07 PM
Rand Boyd [MSFT]

I've got SQL Server 2000 Enterprise Edition & running XP Pro, but it errors on install. Displays "Not supported on this operating system". What can I...

Troy

04-12-2004 02:05 PM
Rand Boyd [MSFT]

What would cause a SQL Server 2000 Clustered server to output the error message listed below. This is a Windows 2000 Advanced Server. The error was...

Dan

04-12-2004 01:57 PM
Rand Boyd [MSFT]

which edition of Windows 2003 do I need for a 3-node cluster

Vic Martin

04-12-2004 04:07 AM
Michael Hotek

That will work. Managing the DPV is challenging to say the least, but it is possible. -- Mike Principal Mentor Solid Quality Learning "More than...

Marx

04-12-2004 04:03 AM
Michael Hotek

Is it possible to setup a clustered environemnt using 2 desktops. I have Windows 2000 AS software and SQL Server Enterprise Edition software at work...

Venkat Alluri

04-12-2004 04:02 AM
Michael Hotek

Hi, Does anyone has experience having Solaris True64 VMS Exchange SQL Server Oracle

kob uki

04-12-2004 03:59 AM
Michael Hotek

We are considering moving from a single 2-way system sql server to a multi-processor cluster. However, we can't seem to get an answer from anyone on...

Corrupter

04-12-2004 03:54 AM
Michael Hotek

I need to upgrade my SQL 2000 cluster to SP3a. The cluster is an Active/Passive 2 node setup connected to an EMC 4700. Has anyone done something...

Paul lane

04-12-2004 03:50 AM
Michael Hotek

Basically, I need to have real active/active cluster solution on SQL server(any MS platform). The windows failover clustering tech is share...

David Liu

04-12-2004 03:39 AM
Michael Hotek

Hi All, I'm on the middle of the sql2000 cluster build. Window2000 cluster went though sucessfullly. Went thought most the steps of the sql cluster...

tuand2001@yahoo.com

04-12-2004 03:36 AM
Michael Hotek

I've noticed with testing my SQL Server cluster failover, that SQL Server is unavailable during the fail over. I noticed that when the SQL Server...

John Oberkehr

04-12-2004 03:36 AM
Michael Hotek

guys: I would like to have your best advise. We am planning to install Passive/Active SQL server Clustering in the production environment that...

White Jul

04-12-2004 03:32 AM
Michael Hotek

What would cause SQL Server 2000 Enterprise Edition databases to be in access restricted mode where only db_owner, dbcreator, and sysadmin? SQL...

Dan

04-12-2004 03:20 AM
Michael Hotek

There's clustering and then there's clustering. ;-) The clustering to which this ng refers is server clustering, whereby one server acts as the...

Tom Moreau

04-11-2004 05:50 PM
Tom Moreau

HI I have two Dell Servers(For high avaiablity each machines have three intel gigabit Networkcards,one for heatbeat,two for clients link) with a disk...

caicia

04-07-2004 10:11 PM
Stephen Strong

Hi. I'm in the process of migrating from a HP XP SAN to an EVA5000. The big issue is how to transfer the SQL Server disks. My plan is to give the...

Bjorn Mobak

04-07-2004 08:26 PM
Stephen Strong

In SQL Server 7.0 NT 4.0 Ent. How do I start and stop the SQL Server service. When I stop the service with the service control applet, it...

Paul Ilacqua

04-06-2004 06:20 PM
Paul Ilacqua

I am having a problem failing over in my SQL cluster. One node is running Windows 2000 and the other (the new one) is running Windows 2003. Both are...

Paul Dube

04-06-2004 02:04 PM
Cindy Gross

I have been tasked with migrating our NT 4.0 domain to a Windows 2003 domain structure. I have a Windows 2000/SQL 2000 Cluster running critical...

Steve

04-06-2004 02:01 PM
Cindy Gross

Is there a way to do testing on a single computer?

Mark DeWaard

04-06-2004 01:54 PM
Cindy Gross

I have read that the cluster admin needs to be a domain admin to setup a cluster. I am using Win2003 and SQL 2000. Is that true ? If not, what...

Hassan

04-06-2004 01:41 PM
frankm

Hi, I would take a look at the Group Policies applied. They reapply themselves once in a while and can produce effects like this. HTH Bjorn

Bjornmob

04-06-2004 12:37 PM
Bjornmob

I have a Windows 2000 that crashed and was part of a active/active SQL cluster (SQL 2000). Instead of reinstall the box with Windows 2000, I...

Paul Dube

04-06-2004 11:42 AM
Bjorn Mobak

For more information on the special considerations if you're using DCs as your cluster nodes, see: 281662 Windows 2000 and Windows Server 2003...

Sefirah

04-06-2004 07:37 AM
Sefirah

Scenario is Windows 2003 Enterprise and SQL Server 2000 Enterprise. I need to know what rights, policies and / or other configurations are needed...

frankm

04-05-2004 10:17 PM
Yuan Shao

I'm planning to move a 2 node cluster with SQL 2000 on Windows 2000 Advance O/S. Any whitepapers or experiences greatly appreated. Helen

Helen

04-05-2004 04:28 PM
Helen

I have a sql2k clustered server. now this server need remote server connection to other server. I have set up remote server on both site, but only...

George

04-05-2004 07:16 AM
George

The data/databases don't know or care if they are clustered. So you can detach them from one machine and attach them to another with no...

Cindy Gross

04-02-2004 01:26 PM
Cindy Gross

I use a simple, inexpensive hub with the power plug glued in place. I rely on the ability of the cluster to use one or more of the 'public'...

Geoff N. Hiten

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

Separate out the failing backups into their own job and see if the problem still occurs. Try scheduling them without a maintenance plan. Also...

Cindy Gross

04-01-2004 04:50 PM
Cindy Gross

There are other considerations. For instance, log shipping gets changes to permissions but replication does not. Replication can also be more...

Cindy Gross

04-01-2004 04:43 PM
Cindy Gross