Hi Guys, I implemented log shipping but if database is open during load the restore is failing. i think i selected "terminate users in database"...

biju george

06-29-2004 08:19 PM
Frank

Hi! I have a problem with linking two servers. I have created a login called "linked" and set full permissions to the pubs-database on booth...

dotNet

06-29-2004 01:33 PM
Joe Belson

Hi, Can we do this: Configuration: A 3-node SQL server cluster that uses a majority node set (MNS) quorum. The quorum would be an MNS quorum where...

06-29-2004 09:04 AM
Geoff N. Hiten

Hello All: Had a working SQL cluster but we had to uninstall SQL. When we go to reinstall SQL (virtual server) on node 1, we get the following...

stan

06-28-2004 08:59 PM
Frank

Hello: I took the MCDBA exam last week. I almost got over the hump, but one question on the test (related to the Subject:) left completely stumped....

Relishguy

06-28-2004 06:25 PM
Dave V

You would think this would be relatively staight forward as they are both Microsoft products. Now the issue is that when trying to run the sql 2000...

beg

06-28-2004 08:33 AM
Rand Boyd [MSFT]

I have a Windows 2000 Advanced Server with SQL Server 2000 Enterprise Edition with SP3A. The cluster is set up as a Active/Active cluster. What...

Mike

06-28-2004 08:33 AM
John Toner [MVP]

Hi, We have a W2k3 cluster with a group MSSQL 2000 sp2. Now when we try to start the setup for MS SQL sp3a it stops saying that it cannot detect the...

Tibi Baraboi

06-28-2004 08:20 AM
Tibi Baraboi

Hi I've got a big probem, my service accounts for the cluster and sql are losing there password from time to time. So I can't move the cluster...

Storch

06-28-2004 06:49 AM
Rodney R. Fournier [MVP]

Have cluster running on two servers; suppose I lost both of them, but have a tape backup of the cluster. Does anyone have some thorough directions on...

Sue

06-28-2004 06:48 AM
Rodney R. Fournier [MVP]

I am trying to install SP3 for sql on a Win2k cluster with 4 nodes. I get the following error when it is running. Unable to verify state of...

thom

06-26-2004 07:07 PM
Tibi Baraboi

I'm a newbie with a big load, and I would appreciate some insight. In my environment, I have an active/active cluster, that also has Snapshot...

Josephine

06-26-2004 04:43 AM
Geoff N. Hiten

A clustered instance of SQL server uses a cluster-wide MSDTC instance instead of a local MSDTC instance on each host node. As such, the...

Geoff N. Hiten

06-25-2004 12:03 PM
Geoff N. Hiten

I understand it is recommended to have a private LAN for inter-cluster communication but we are not able to do that due to resource limitations. We...

06-25-2004 11:08 AM
Geoff N. Hiten

Is there any way that we can use two drives on a single database and server. Example, my database is located at drive C and that drive becomes full....

Aner T. Ortega

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

Hi all, I have some trouble with SQLAgent...when I try to schedule a job that invokes a script (vbs, java, cmdshell,...), SQLAgent crashes at...

Maurizio Camurati

06-25-2004 03:28 AM
Maurizio Camurati

Hi, My end goal is an active-passive sql2000 cluster running on 2 windows 2003 ee nodes. I have installed the os, got the san drives recognised and...

RobE

06-25-2004 03:17 AM
RobE

Hi All We're doing a demo tomorrow. However we only have a single node available and SQL 7 clustering wizard tells me that there is no cluster. There...

Barry Lynch

06-24-2004 12:15 PM
Barry Lynch

Hello, We are setting up a 2-node active/active SQL 2000 cluster on Windows 2003 ent. ed. Our DB team writes MS Access XP front-ends for client...

JJP

06-24-2004 10:18 AM
JJP

Since SQL uses 1433 as the default port and each instance sounds like its running on its own node, I would say yes? Cheers, Rod MVP - Windows...

Rodney R. Fournier [MVP]

06-24-2004 09:18 AM
Geoff N. Hiten

I've upgraded our SQL2k server to cluster using Dell 2650's attached to Powervault chasis -- U320 all the way through. Our db's are 90% read, and...

open to suggestions

06-24-2004 09:15 AM
Geoff N. Hiten

I would like to setup SQL Enterprise in a 2 node cluser to act in a "active/active" form. I may be using the wrong termanolgy. I would like to have...

MIke Nolet

06-23-2004 08:33 PM
Rodney R. Fournier [MVP]

Hi, We have a SQL 2000 cluster server. We need to run a query on an access database. We have set up a linked server, however we always get the...

PC

06-23-2004 11:01 AM
Geoff N. Hiten

In a two node SQL server cluster, with each computer in the cluster storing the database on its local hard drive, is it OK to have the quorum drive...

06-23-2004 10:43 AM
Andrew J. Kelly

I have a windows 2000 server that runs SQL 2000 Etr. I need to change the ip address of the heartbeat. I was wondering what the best way to change...

Michael

06-23-2004 10:12 AM
ghuddleston

I'm in the process of setting up my first W2K3 / SQL 2000 cluster and I have a few questions with regards to MSDTC. Documentation I have says that...

tech_arch_guy

06-23-2004 09:37 AM
Geoff N. Hiten

Our scenario: - web servers windows 2003 with web application using com+ activex Dll, on DMZ - sql server Ent 2000 on windows 2000 server advanced,...

Dario Sala

06-23-2004 09:02 AM
Dario Sala

I'm planning on installing SQL 2000 on a 2 node Windows Server 2003. I want to have both nodes to be active SQL servers and they will both be...

Christian Poupart

06-22-2004 02:12 PM
Geoff N. Hiten

See error below "An error occurred while creating virtual server resources for clustering. The system cannot find the file specified."

Jason

06-22-2004 12:18 PM
Jason

For this purpose, TS and Remote Desktop are NOT the same. Remote desktop should not interfere with the install, however, do not remote into...

Geoff N. Hiten

06-22-2004 10:44 AM
Geoff N. Hiten

The only time you turn it off, as far as I know of, is when you have the max number of processors installed already. Example: Windows XP support...

Rodney R. Fournier [MVP]

06-21-2004 09:38 AM
Geoff N. Hiten

Is SQL Server clustering supported/recommended using a NAS/RAID to hold the database? Here is the hardware setup Let's say there are 25 computers on...

06-20-2004 06:32 PM
Stephen Strong

I think you should - copy the mdf and ldf file off to a safe location - uninstall sql server from the cluster - reinstall sql server to the cluster -...

Vikram Vamshi

06-20-2004 06:25 PM
Vikram Vamshi

Hi Guys, i am managing an OLTP system using sql 2000 and these system is running for last 4 years and now having 25 million records for main...

biju george

06-20-2004 06:21 PM
Stephen Strong

Normally the installation should not time out because there are multiple drives in the resource group. There is not a setting to prevent this....

Rand Boyd [MSFT]

06-18-2004 08:12 AM
Rand Boyd [MSFT]

No SPacks on SQL? Ever heard of Slammer? I would say make sure you have a good backup and apply them! Cheers, Rod "The American"...

Rodney R. Fournier [MVP]

06-17-2004 07:42 PM
Rodney R. Fournier [MVP]

I've got 2 Arrays on my SAN. Array 1 is 66 gb. Array 2 is 230 gb. I've partitioned the drives in MS2003 this way: Array 1, Drive Q: (Quarum)...

Travis

06-17-2004 07:40 PM
Travis Willard

Security Best Practices tell us to remove BULITIN\Administrator from SQL Server Logins. Is this also true in SQL Server 2000 Cluster. Many...

John

06-17-2004 01:39 PM
Rand Boyd [MSFT]

We have a SQL 2000 cluster that is running on two Windows 2003 Enterprise boxes and everything works fine, except that after the cluster has...

-DB

06-17-2004 12:46 PM
Rand Boyd [MSFT]

Currently, we have two sets of SQL 2000 cluster servers in two different regions. We are trying to implement log shipping for redundancy. Does log...

newby

06-17-2004 12:33 PM
newby

Currently, we have two sets of SQL 2000 cluster servers in two different regions. We are trying to implement log shipping for redundancy. Does log...

newby

06-17-2004 12:31 PM
newby

I am looking to go into a DBA role and I keep hearing about clustering servers. Is there anywhere I can go to learn about it? Or can someone please...

GeorgeP

06-17-2004 08:20 AM
GP

Two 4GB mem clustered sql servers. Two sql instances. If leave 1GB for the OS. 1.5GB for each instances. Still need enable AWE? Thanks a lot!!! K.

Karen

06-16-2004 06:53 PM
Andrew J. Kelly

Hi, We want to run a two node server cluster with Windows Server 2003 Enterprise and SQL Server 2003 Enterprise. How many copies of SQL Server...

Todd Harrington

06-16-2004 04:09 PM
Rand Boyd [MSFT]

Hello everyone! We currently have a one node cluster (w2k3 and sql2000ent) and have had it this way for a while waiting on the second server to...

Erik

06-16-2004 01:49 PM
Erik

Help: Event Type: Error Event Source: MSDTC Client Event Category: Cluster Event ID: 4389 Date: 6/16/2004 Time: 11:44:57 AM User: N/A Computer:...

06-16-2004 10:51 AM

Hi, i try to install a SQL2000 on Windows 2003 Ent.; i enable Network DTC and manually configure a MSDTC Resource reading the article...

06-16-2004 08:42 AM
Rand Boyd [MSFT]

Hi, If I have an existing SQL 2000 server that I want to move into a cluster, will I need to reinstall from scratch, or can I simply upgrade the OS...

Robert Reinstein

06-16-2004 08:40 AM
Rand Boyd [MSFT]

How can I install the SQL MSDE 2000(SP3a) with a instance name on a windows 2003 cluster server. (The MSDE config haven't to be cluster aware, I only...

GvRijssen

06-16-2004 03:41 AM

Hi i need to configure 2 sql2000 server (S1 e S2) in a/a mode with two database on the first node and other two database on the second node. I have...

06-15-2004 08:53 AM
Rodney R. Fournier [MVP]