Each Virtual Server gets a single instance. It can be either a named instance or a default instance, however only one such virtual server...

Geoff N. Hiten

07-06-2004 11:59 AM
Geoff N. Hiten

I got a question/prob: I changed the ip addy of my CLUSTER (physical) and now my virtual servers won't pass the "online pending" stage. They...

:\)

07-06-2004 09:08 AM
Rodney R. Fournier [MVP]

Ref KB298568 the Note after last step (step 7) states that you should restore recent backup of master. Isn't this defeating the object of rebuilding...

Tim G-J

07-06-2004 06:24 AM
Tim G-J

thanks for the fast and (really) good answer "Uttam Parui" <uttamkp (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag news:kXeyPprYEHA.228...

Daniel Neubacher

07-06-2004 02:08 AM
Daniel Neubacher

is it talking to SQL 7 Server via linked server as per below by any chance...

Andy Ball

07-03-2004 03:53 PM
Andy Ball

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...

07-02-2004 05:30 PM
Uttam Parui[MS]

Hi I had a sql 2000 cluster with 2 node active\active and I would like to rename my sql default name to another name but MS recommend to uninstall...

Frank

07-02-2004 05:25 PM
Uttam Parui[MS]

MS SQLSever service accounts should not be members of the local Administrator or Domain Admins groups. Is this also troug for SQL Server...

John

07-02-2004 04:51 PM
Uttam Parui[MS]

Hi all! how many failover nodes are supported by SQL SRV 2k on a windows server 2k3 EE cluster? I have only found information about 4 failover nodes...

Axyl104

07-02-2004 04:37 PM
Uttam Parui[MS]

Hi all, I need to know how to install sp3 of sql on my sql cluster.Sql server runs properly now.Is there any notes to pay attention to while...

John Park

07-02-2004 02:58 PM
Uttam Parui[MS]

Hi! I'm about to install Sql2k in a cluster enviroment. The problem is the collation. In my other Sql2k database servers (non cluster) i did an...

JohanSql

07-01-2004 07:19 PM
Bart Duncan [MSFT]

We have about 40 DB's blackening 40 web sites running on a single SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to the next...

Mike B.

07-01-2004 10:40 AM
Geoff N. Hiten

Here's the setup: Windows 2003 Enterprise (Fully Patched) SQL Server 2000 SP 3 Quorum(E:) and Data(F:) disks on same external SCSI Raid Here's the...

Jim Rackley

06-30-2004 12:18 PM
Jim Rackley

I have a user table (my_tbl) which receives an insert/update/delete (DML) operation every 3 to 5 seconds. It has a trigger (TRG1) which creates an...

LCaffrey

06-30-2004 04:26 AM
LCaffrey

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 09: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 02: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 10: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 09: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 07: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 09: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 09: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 09: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 07: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 07: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 08: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 05: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 01: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 12:08 PM
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 10: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 04: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 04: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 01: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 11: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 10: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 10: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 09: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 12:01 PM
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 11: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 11: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 10: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 10: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 03: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 01: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 11: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 10: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 07: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 07: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 07: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 09: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 08:42 PM
Rodney R. Fournier [MVP]