The instance names on my w2k8/sql2k8 cluster do register the forward DNS lookup entries, but the reverse entries are missing. The nodes themselves do...

Hans

10-13-2008 10:52 AM
Hans

Scenario: Two months ago: Two node SQL 2005 cluster, one node evicted, and active node had SQL Server reinstalled under the default instance but...

jameseiv

10-12-2008 02:16 PM
jameseiv

Hi All SQL Gurus Here is my scenerio I have a Win2003 SQL Server 2000 Cluster server. Now the plan is to upgrade to SQL2005 But they do not want to...

Jason

10-10-2008 09:25 AM
Geoff N. Hiten

Hi, Is there any way to install SQL Server patches without causing downtime? We want to patch a 5-way A/A/A/A/A cluster but we find that always the...

Mauricio Tamayo Ortega

10-09-2008 12:20 PM
Geoff N. Hiten

Hello After a reboot (following an SSIS install) the cluster service won't start on my passive node. I see this error in the system log: Cluster...

Cranfield

10-09-2008 12:17 PM
Cranfield

common misunderstanding, Microsoft Failover clustering is a "shared nothnig" cluster model, and therefore the SQL instance can only be online on 1...

Edwin vMierlo [MVP]

10-09-2008 09:12 AM
TLG

is there an advantage in using WITH INDEX in select statement when PK_ID is a clustered index , will this speed up the process? SELECT xml FROM...

Emil

10-08-2008 07:36 PM
Andrew J. Kelly

Hello I have a problem for upgrade my cluster sql 2000 on windows 2003 R2 to Sql 2008 enterprise evaluation. When i have the message...

Pascal Greencode

10-08-2008 04:07 AM
Pascal Greencode

Howdy, all. I'm trying to install a hotfix to an active/active cluster. There's nothing in the docs about it, and while I know there's an article...

M Bourgon

10-07-2008 06:30 PM
GPage

I currently have an SQL 2000 active/passive cluster that has a quorum drive. I am planning on setting up an additonal SQL 2005 active/ passive...

shamus.sadai@uth.tmc.edu

10-03-2008 06:25 AM
Edwin vMierlo [MVP]

Hi all, I have a 2-node active/active SQL 2005 SP2 cluster running on 2 Windows Server 2003 x64 edition boxes. I am considering adding a 3rd node on...

10-02-2008 09:28 AM
Geoff N. Hiten

I'm attempting to set up a 2 node active/active sql 2005 (ent edition) failover cluster with an HP 2000i MSA iscsi storage box. Server is 2003...

JayInNC

10-01-2008 04:01 PM
JayInNC

I have a new 2 node active\passive Windows 2003 R2 SP2 64bit, SQL 2005 SP2 (with latest patches) installed. When I failover from node1 to node2,...

kj2n

09-29-2008 10:26 AM
kj2n

Hi We have an application running on an NLB cluster in the DMZ. Application data is stored on a standalone SQL 2005 Std server located not in the...

tagtagboys@gmail.com

09-28-2008 08:55 AM
egsj

Hi, we have 4 identical nodes each with 1TB RAID10 drive. Accessing a quorum over Fibre Channels is also possible We want the best mix of...

Michael Kugler

09-26-2008 05:48 PM
Mohit K. Gupta

I have read this great bit of news, however I cannot find any documentation on how to configure it. Can someone point me in the right...

Adminicrater

09-25-2008 06:17 PM
Russ Kaufmann

We have a 2 node 64-bit Windows 2003 Active/Active Cluster with 2 instances on each node. Each node has 2 virtual servers/named instances; 1 SQL...

Reuben Sultana

09-25-2008 10:51 AM
Raman Gosala

I have to move a SQL Server 2000 active/passive cluster from one subnet to another in the same domain. I've read the relevant Q244980 and...

Tony Dawson

09-24-2008 02:21 PM
Tony Dawson

Hello I have the folowing situation on my company: Someone configured an Active-Passive SQL 2K5 Cluster configured with only one group!!! This group...

Bruno

09-24-2008 02:01 PM
Linchi Shea

I have a MSCS Cluster residing within two esx hosts, there are three shared disks and a quorum drive, each is currently available to the server and...

edv1

09-23-2008 10:00 AM
Geoff N. Hiten

Hi all! I am designing a virtualized "Always On" solution for a client using SQL2k8 (Edition TBD) + Win2k8 Hyper-V. I will have 8 boxes conforming a...

Alberto Ortega

09-22-2008 06:42 PM
Alberto Ortega

Hi guys, Please, how can I write, after clustering process, the final clusters in a table? Best, -- Paulo Carvalho

Paulo

09-22-2008 08:19 AM
Roy Harvey (SQL Server MVP)

I'm trying to install SQL Server 2005 on a one-node Windows Server 2008 failover clustering, but I'm getting the following error message: "The drive...

Carlos Felipe França da Fonseca

09-19-2008 03:26 AM
Carlos Felipe França da Fonseca

My 2 -node sql clusters (active/passive) rebooted today because of power failure. When they came up SQL server agent is showing online pending...

Sonia

09-18-2008 09:31 PM
Geoff N. Hiten

Hi, Is SQL2000 supported on a 64-bit Windows 2008 cluster? These are not Itanium processors, AMD I think. We just want to run it on there for a few...

JJP

09-18-2008 09:59 AM
JJP

I have to re-IP our SQL 2005 failover cluster to a new IP and I have looked at the following KB articles. How to change the network IP addresses of...

Jeremy

09-18-2008 08:55 AM
Geoff N. Hiten

Hi, I tested a failover cluster solution with Windows 2003 and SQL Server 2005 using 2 nodes with optimal result. Now I'm interested to add a third...

Pablo Garateguy

09-18-2008 05:35 AM
Edwin vMierlo [MVP]

Hi All, Currently, our Prod databases located in the 3 SQL instances on the 2 physical nodes cluster servers. I need add three new (powerful) nodes...

Chen

09-16-2008 10:07 AM
Linchi Shea

HI, I have 2 nodes on cluster. I installed SQL clustering. Recently, there is a need to have IP changes to the environment. I followed closely from...

irewan

09-15-2008 02:50 PM
Dan

I try to install MS SQL 2000 Enterprise to an existing Cluster. When it ask me i put the SQL Server Virtual name i type it and when i press Next,...

Francois Coallier

09-15-2008 09:46 AM
Francois Coallier

Hi, I want to introduce myself, I am Tommy and I am 32 year Network Engineer from PA. I am dipping into some SQL stuff that I have never dipped...

tommypa

09-12-2008 04:45 PM
Geoff N. Hiten

We have built a SQL Cluster and all goes well with the failover of the Instances when either node is gracefully shutdown, ie the instances...

Simon B

09-11-2008 09:22 PM
Linchi Shea

I have a two node cluster (active/active). When I try the failover with the cluster administrator tool I have seen that it occurs 15-20 seconds to...

Pasquale

09-10-2008 09:19 PM
Andrew J. Kelly

I have moved some times a SQL Server resource group from a node to another one in a two node cluster environment. I have registered two different...

Pasquale

09-10-2008 04:30 AM
Edwin vMierlo [MVP]

Hi I'm new to SQL server so i'm hoping that some of you pros out there can help me out. We are looking to perform an upgrade on our SQL clusters....

apatel4000

09-09-2008 07:47 PM
Jammy

How setting the minimum memory size for SQL Server in a clustered environment in order to improve the performance during a failover? Thanks

Pasquale

09-09-2008 04:42 PM
Geoff N. Hiten

Hi All, I am receiving this error when attempting to install SQL2K5 on the first node of my cluster. Setup 2 Node Failover cluster - connected via...

Jammy

09-08-2008 03:48 AM
Jammy

Hi, We have sql server 2000 cluster, with 4 (active-passive) instances. Shared drives (all system and user databases) are EMC. Since databases are...

Pedja

09-02-2008 06:23 PM
Linchi Shea

Quick and easy question. What is the proper procedure to shutdown a 4 node active SQL cluster. I need to bring the servers down for disaster...

AJ

09-02-2008 03:05 PM
Geoff N. Hiten

from all the documentation i have read, i would need a separate set of volumes to add a SQL2005 clustered instance to my clustered 2000...

Willy

09-02-2008 02:49 PM
Geoff N. Hiten

I need to install Reporting Services in a cluster environment. I have two SQL Server clustered instances, each one uses 2 disks on a SAN (one for...

Pasquale

09-01-2008 11:00 AM
Pasquale

I have installed SSIS 2005 in a two node cluster not as clustered resource. In order to render available the SSIS package in a node to another node I...

Pasquale

09-01-2008 10:28 AM
Pasquale

In order to optimize failover cluster performance, I have read it is useful to use a static port and not the dynamic port (e.g. 1433). To use a...

Pasquale

08-31-2008 11:09 PM
Linchi Shea

I have a two node cluster (a/a) with two SQL Server instances. Now, I have to plan to install SSIS, but not as cluster resource. Each node have a...

Pasquale

08-30-2008 05:17 PM
Geoff N. Hiten

I have a active-active node running well, and need to add 3rd node. following bol I was able to install 2 instances on 3rd node, however, I only can...

George

08-30-2008 05:11 PM
Geoff N. Hiten

hello to everyone , We have in our company a two nodes active-passive cluster with SQL Server 2000 SP4. Recently one of our customer required from...

Cipher

08-29-2008 03:15 AM
Cipher

I tried to install SQL 2005 Cluster (Active/Passive) on a Windows Server 2008 Datacenter but the cluster feature is grayed out. I there a patch for...

Hien

08-28-2008 11:10 PM
BethP

I have a 2 node SQL 2005 cluster (active-passive) that currently has a single direct attached SCSI array for it's shared storage. Because we've...

fignewton

08-28-2008 04:00 PM
fignewton

We currently have a 2-node SQL 2005 cluster. We need to break the cluster and turn it into a standalone server without losing the existing...

Aaron

08-28-2008 03:36 PM
Tom Moreau

In setting up a 2-node cluster (active/active) do I need to have an additional SQL 2005 Enterprise license for the second node? Also, I'm new to...

Russ Sparks

08-28-2008 12:16 PM
Mohit K. Gupta