I'm kind of planning to transfer databases from server1\instance1 (on cluster-a) to server2\intance1 (on cluster-b) by detaching them...

Robert Hindla

07-07-2009 12:11 PM
Robert Hindla

Hello, I am trying to setup a SQL 2005 SP2 mirroring with auto failover. I need a witness server for such configuration. Is the witness server a...

EX Admin

07-02-2009 02:46 PM
EX Admin

I have a 2 node sql 2005 cluster (64 bit ent edition) running on Windows Server 2003 (64 bit ent edition) utilizing an HP iscsi storage array....

JayInNC

06-30-2009 02:55 PM
JayInNC

Microsoft's documentation is far from clear. I need some clarification. I need to build a test environment and then convert it to production. ...

Paul

06-26-2009 03:55 PM
Paul

Good afternoon. We have a SQL 2005 cluster on our network (single domain). I am cleaning up AD and need to move the SQL cluster to a new OU. ...

UnderCoverGuy

06-23-2009 09:04 PM
UnderCoverGuy

Good afternoon. We have a SQL 2005 cluster on our network (single domain). I am cleaning up AD and need to move the SQL cluster to a new OU. ...

UnderCoverGuy

06-22-2009 02:02 PM
UnderCoverGuy

I have an existing stand alone SQL 2005 server (Server1) that has approx 10 DB's on it. We want to cluster active passive. I have an identical...

John

06-20-2009 08:12 PM
John

My customer wants to use non-default installatin direcotries but when we get to that page in the wizard, the first installation path field is...

Camilo

06-19-2009 04:25 PM
Camilo

Hello, Is is possible to configure Windows2008 Active/active cluster on BCV disks? Has anyone implemented that? Background: Node1 has OLTP...

Abba

06-19-2009 09:23 AM
Linchi Shea

Attempted to setup SQL2008 within Server 2008 Cluster. the 2 nodes of the cluster are in different networks. Am able to fail over the cluster core...

Ian

06-18-2009 09:56 AM
Geoff N. Hiten

Hi, With clustered SQL 2005 installations I always needed to create a service account (and security group) for my clustered installations (both SQL...

zinck74

06-16-2009 02:36 PM
Geoff N. Hiten

If we configure 3 nodes in SQL Cluster and keep all active, will these all nodes work simultaneously, i mean will it share the client's request and...

Shamshad Ali

06-15-2009 10:17 PM
news.microsoft.com

During my troubleshooting of a cluster issue I had, I tried to remove an instance of SQL Server 2005 from the cluster - this failed, but it...

Mark Allison

06-11-2009 12:51 PM
Geoff N. Hiten

OK, now two options: 1- Assuming if I don't use table partitioning on online database (Cluster A, B & C). Now may i get performance by using load...

Abba

06-11-2009 02:50 AM
Mark Allison

If I have a large SAN, Can I create many SQL Server Clusters? on the otherway, is it possible to create many cluster servers on one available...

Shamshad Ali

06-10-2009 04:37 PM
Russ Kaufmann

I have one another design i implemented earlier. and that has more maintenance costly so i thougth about the clustering; also it has some drawbacks i...

Shamshad Ali

06-10-2009 09:10 AM
Linchi Shea

Hi everybody, Perhaps this is a bit off topic, but I could not find a better group to ask. I currently have a two node Microsoft cluster. One of my...

Adam Przestroga

06-09-2009 11:48 PM
Adam Przestroga

I installed SQL Server 2008 2 node Cluster on a Windows Server 2003 Enterprise 64-bit Server. I opted for "Advanced Cluster Preparation" Option and...

JP

06-08-2009 02:27 PM
scottdotnot

"Geoff N. Hiten" <SQLCraftsman (AT) gmail (DOT) com> wrote Excellent post, btw. Thanks Geoff. -- Russ Kaufmann, MVP, MCSE: Messaging and...

Russ Kaufmann

06-06-2009 07:36 PM
Russ Kaufmann

can we mirror two sql server at a time of in same group From http://www.developmentnow.com/g/99_2006_8_0_0_0/sqlserver-clustering.htm Posted via...

Gita

05-28-2009 07:04 AM
Tibor Karaszi

Thanx for the 4) approach, I did not consider it. Thanx Massimo "Manpreet Singh" <ManpreetSingh (AT) discussions (DOT) microsoft.com> ha scritto...

mastiff

05-27-2009 01:07 PM
mastiff

Hi all. Any assistance regarding this would be greatly appreciated. We have configured two sql server 2005 clustered environments - one will...

xyberdobs

05-21-2009 03:57 PM
Geoff N. Hiten

Looking for advice rather than the solution to a specific question here. I'm trying to make the case for creating a number of additional instances...

YaHozna

05-19-2009 09:34 AM
frankm

I have a Windows Server 2003 Enterprise Edition sp2 - 2 node cluster. Installed is SQL Server 2005 sp2 across both nodes. I am logged into the node...

frankm

05-18-2009 09:14 AM
frankm

Hi There I want to import my DTS package from sql server 2000 to sql server 2008 with cluster. I save all the required packages from sql server...

Amirullail

05-18-2009 08:45 AM
frankm

I don't know if this is the right place to ask this, if not could it be moved plz. We have a 2 node (active/passive) sql cluster. SSIS is also...

jsl2000

05-13-2009 03:26 AM
jsl2000

Current Environment: SQL 2005 Enterprise x64 SP2 Active / Passive cluster running on Windows 2003 Server. Problem: Need to apply OS patches and...

Greg

05-08-2009 01:57 PM
Greg

Hi, We are running a database on a streched cluster with a SAN. The tempdb is on a clustered disk and is replicated to the other site. This...

jan.devylder@gmail.com

05-08-2009 10:23 AM
Geoff N. Hiten

Dear It Pros, i've installed Sp3 for SQL 2005 on a 2 Node A/P cluster. I paused the 2nd Node and installed successfully SQL Sp3 on the first and...

Thomas Leinberger

05-07-2009 04:05 AM
Uri Dimant

Hi, I want to cluster SQL 2008. I know of the failover clustering feature in combination with Windows failover clustering. But, is it also possible...

Aeolus

05-03-2009 10:10 PM
Geoff N. Hiten

Hi guys, I'd appreciate some help with a problem I have. It's a web based application. So its being accessed via one IP. I need it so if one of...

Gorge Lucas

05-01-2009 07:31 PM
Gorge Lucas

If I install SQL 2008 on a W2K8 or W2K3 R2 cluster, can the individual (non-primary) instances run as users in different child domains of the...

Alex Baker

04-30-2009 10:28 AM
Alex Baker

Dear Experts, I have a two node cluster SQL_N1 & SQL_N2, I installed setup from Node 2 where IIS was installed and in Node 1 there was no IIS...

Girish J Bhatia

04-27-2009 03:56 AM
Girish J Bhatia

Hi, I have read lot of articles on SQL Server 2005 clustering and find out that the SQL Server 2005 doesn't support Active/Active clusters out of the...

Adeel Ahmed

04-23-2009 06:58 AM
Adeel Ahmed

Does anyone know what the reason is for the folowing paragraph on http://support.microsoft.com/kb/889654: Note If you are running Microsoft SQL...

Hans

04-22-2009 04:34 AM
s_m_b

I was asked to look for clustering SQL to increase availability. I saw HP DL380 G5 storage server but was told that it was not optimized to run SQL...

htt

04-22-2009 04:26 AM
s_m_b

Hello, I am still pretty new to clustering. I will be creating clusters on SQL2005 with BizTalk 2006 R2 as follows: 1. SQLCluster 2. ...

DetRich

04-21-2009 06:46 PM
bass_player

I have a Active/Passive cluster and have installed the SQL 2005. What I would like to know, before I proceed with my configurations (since it is my...

=?Utf-8?B?aXF2MQ==?=

04-21-2009 09:55 AM
Russell Fields

We are setting up a new SQL 2005 cluster on Windows 2003 Enterprise servers. The new configuration will be used to replace a current implementation...

Dan

04-20-2009 03:14 AM
Gotcha

Are there any known issues if you change the SQL-TCP port from dynamic- to the standard 1433 port in a cluster environment. We have an application...

GumbleManja

04-20-2009 02:43 AM
Gotcha

Hi All, I have a strange error with SQL2005 x64 on a HP DL580g5 x64 (Win23k R2 + Sp2). I've installed SQL2005 DB and cluster it no problem at...

Sean (UK)

04-15-2009 04:32 PM
Michael.varriale

Hi all, Could someone please help me with some advises or whitepapers if available regarding the SQL2005 move from Direct SCSI attached Storage to...

Pluto

04-15-2009 03:26 AM
Pluto

Hi, I have configured the sql 2005 A\P cluster. I am noticing that the SSMS, Business Intelligence etc are missing after the cluster install. Tried...

Manoj Kumar

04-13-2009 04:57 PM
Manoj Kumar

Hello, Just beginning the OS 2008 and SQL 2008 process. Does MSCS mandate a domain service account to run the cluster? Does SQL 2008 require domain...

Joe

04-10-2009 09:37 AM
Geoff N. Hiten

We are replacing one SQL 2000 cluster node. The existing two nodes have 4GB with the /3GB switch - no PAE. AWE is not enabled. The new node will...

Randy

04-08-2009 03:45 PM
Randy

1) We have a two node SQL Server 2000 SP4 Ent on Windows 2003 Ent SP2 failover cluster. One of the nodes is not available and we are trying to add a...

Randy

04-08-2009 11:49 AM
Geoff N. Hiten

We have a 2 node SQL 2005 64bit cluster with Active Passive configuration and 2 SQL instances. I'm trying to install Analysis services on the SQL...

SyNEttech

04-08-2009 01:14 AM
Charles Wang [MSFT]

Hello, "Mohit K. Gupta" wrote: All my servers are in the same local AD domain. Thanks for tips.

anxcomp

04-05-2009 02:06 PM
Mohit K. Gupta

I have a SQL Server 2000 cluster installation to complete. This installation will be a 2 node cluster that will be active / passive cluster. Should...

Joe K.

04-03-2009 02:11 PM
Geoff N. Hiten

On a 2 node virtual server that has an existing SQL Cluster installed, is it possible to install a second SQL instance using on the same virtual...

Robin9876

04-02-2009 01:43 PM
Geoff N. Hiten