We are a SQL 2008 std 64 bit on windows 2008 enterprise 64 bit shop and use two node active passive clustering. Currently our heartbeat network is...

OceanDeep via SQLMonster.com

12-22-2009 05:30 AM
Mark Broadbent

The management studio didn't get installed on our new two-node cluster. When I try to do 'add feature', via 'new standalone or add features',...

s_m_b

12-22-2009 05:29 AM
Neil Matthewson

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

12-17-2009 10:29 AM
Mia

Hello, System config: SQL2005 Enterprise in Windows2008 Cluster 2 Nodes 1 SQL- Instanz ca. 20 DB's Is it possible to change Sql2005 Enterprise to...

bienchen

12-15-2009 10:44 AM
Geoff N. Hiten

Hello! We will be installing SQL Server 2008 64 bit EE on Windows 2008 EE (Active/Active cluster). I would like to confirm following...

Igor Marchenko

12-14-2009 06:08 PM
BrentM

I am configuring a 2 node windows 2008 failover cluster for SQL 2008. I want to put three instances in the cluster. Is it a better design to...

Go Oilers

12-13-2009 02:49 PM
Geoff N. Hiten

I didnt install or configure the cluster but it appears to be setup correctly per Microsoft standards. Now I'm attempting to test the failover of...

Rich

12-13-2009 02:48 PM
Geoff N. Hiten

Hi ! I wonder if it is possible to have standard and enterprise edition installed on the same kluster , Sql-server 2005, windows 2003 enterprise...

Ulf Fernholm

12-11-2009 02:27 AM
Ulf Fernholm

SQL Server and SQL Server Agent service cannot start on third server. We have 2- node Windows Enterprise 2003 x64 servers clustered in active/active...

Dovla

12-04-2009 04:32 AM
Dovla

We had 2 Active/Passive cluster on Windows 2003 SP2 - SQL Server 2005 EE SP3, Cumulative patch 1 -------> 32 bit SQL Server on 64 bit O/S. We wanted...

A

11-26-2009 01:08 PM
Geoff N. Hiten

Hi, We have an existing production clustered SQL server with a default instance and a named instance. I need to configure Reporting services on the...

Sheethal

11-25-2009 09:10 PM
Alen Teplitsky

Hello! We will be installing SQL Server 2008 Active/Active Cluster on Windows 2008. SAN engineer told us that all space will be allocated accross...

Igor Marchenko

11-24-2009 02:57 PM
Igor Marchenko

How many nodes can SQL Server Clustering 2008 support? and How many ACTIVE nodes can SQL Server Clustering 2008 support? Thanks. EggHeadCafe -...

Mynor Bolanos

11-23-2009 12:37 PM
Mynor Bolanos

Hello! We are preparing to install SQL Server 2008 Active/Active Cluster on Windows 2008. We are currently contemplating whether we need a...

Igor Marchenko

11-23-2009 09:58 AM
Mynor Bolanos

Installed the first node and it appeared that the installation only installed to the first physical node?! dont remember seeing a physical...

Mark Broadbent

11-19-2009 07:26 AM
Mark Broadbent

Hi, We want to install 4 active SQL nodes and 2 passive nodes. do we have to install 4 named instances or may it be 4 default instances? will we...

bruno reiter

11-18-2009 10:50 AM
Geoff N. Hiten

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 08:18 AM
Mia

Hello, I cannot install SP2 on a new node that was added after SP2 applied to the primary. We had the following scenarios. Node A SP2, node B...

Andrea Gallazzi

11-17-2009 01:45 PM
MikeyTheMap

More than anything, it’s a generic interface to your data. Any data. If it can be shown in a tabular format, we can work with it. (six months of...

Mia

11-17-2009 10:09 AM
Mia

Hello! I was wondering what is the recommend service pack/patch level for SQL Server 2008 cluster installation on Windows 2008. Thanks, Igor

Igor Marchenko

11-12-2009 08:59 PM
Igor Marchenko

I'm moving our production DB from a stand alone install to an active/passive cluster. Current system is running Windows 2008 and SQL 2008 SP1,...

phavel

11-10-2009 11:53 PM
Balaji

Hi there, When setting up Replication between on SQL 2005 Server and a 2 Node Cluster SQL 2005 server I got an error message, searching about it, it...

Jordi Fernandez

11-10-2009 11:32 AM
ico ico

I'm moving our production DB from a stand alone install to an active/passive cluster. Current system is running Windows 2008 and SQL 2008 SP1,...

phavel

11-09-2009 11:38 PM
Balaji

I'm moving our production DB from a stand alone install to an active/passive cluster. Current system is running Windows 2008 and SQL 2008 SP1,...

phavel

11-08-2009 09:51 PM
phavel

I'm moving our production DB from a stand alone install to an active/passive cluster. Current system is running Windows 2008 and SQL 2008 SP1,...

phavel

11-08-2009 08:05 PM
phavel

I'm moving our production DB from a stand alone install to an active/passive cluster. Current system is running Windows 2008 and SQL 2008 SP1,...

phavel

11-08-2009 08:04 PM
phavel

Hello, I am running SQL 2005 on W2K3. I have a cluster for SQL Server. There are two groups: SQLA and SQLB. I run SQL Setup to install two SQL...

DetRich

11-05-2009 05:57 AM
Edwin vMierlo [MVP]

we use single mssql2005 run a SP need around 20min but same data and same SP run in sql2005 cluster need around 50min anyone know the problem, we...

ken

11-05-2009 05:50 AM
Edwin vMierlo [MVP]

All is in the title. Microsoft are saying everywhere (included Books Online) that a SQL Server Cluster needs a domain account for the startup...

Med Bouchenafa

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

We have an active/active SQL 2005/Windows 2008 2 node cluster that has 1 instance running on node 1 and 1 instance running on node 2. Our DBA wants...

JJP

11-04-2009 09:48 AM
JJP

is this doable? - and if so what are the prerequisities? i have the 2 node cluster running with shared disk,MPIO and ready to go -wanted to check...

Pierre

11-04-2009 03:43 AM
Balaji

Hello, I've setup Win2k3/SQL 2005 clusters in the past but I've never had to deal with Multiple instances. I will be installing each instance in...

Stuart

11-03-2009 12:08 PM
DetRich

I have read that best practice for failover cluster with SQL 2008 is 4 disk per instance. Can someone please explain what the purpose of the 4...

Go Oilers

11-03-2009 11:12 AM
DetRich

Can someone give me instuctions or lead me to instructions on how to build a MS SQL 2008 Cluster on MS Windows Server 2008?

Antocobb1

11-02-2009 11:51 PM
Balaji

We are running an active/passive SQL 2000 Ent. SP3 environment. I need to remove 2 physical disk as SQL Server dependencies. The disks are not being...

RobinMC

10-28-2009 01:23 PM
Geoff N. Hiten

Is there a faq on fail-over cluster licencing using win2k8 r2 and sql server 2k8?

Cypher

10-26-2009 02:13 PM
Russell Fields

I have read a thread here on how to properly shutdown a SQL 2000 and 2005 cluster and wondering if there is any difference with SQL 2008 cluster....

OceanDeep via SQLMonster.com

10-26-2009 10:30 AM
Geoff N. Hiten

I know it is recommended to cluster MS DTC, and may even be required in a Windows 2003/SQL 2005 clustered environment, but if a person is only...

daveberm

10-23-2009 10:00 AM
Geoff N. Hiten

Hello, Is it possible to have a SQL2008 2-node A/P cluster with one node which is a Physical server and the other node a Virtual (VMware) server?...

Abba

10-23-2009 09:15 AM
daveberm

"Andrea Caldarone" <andrea.caldarone (AT) poste (DOT) it> wrote This question is best suited for the Cluster newsgroups, not General. I...

Ace Fekay [MCT]

10-23-2009 03:39 AM
Andrea Caldarone

I am a server admin and not a dba so please ignore my ignorance. If I have a two node SQL 2008/Windows 2008 fail over cluster, what is the benefit...

Go Oilers

10-20-2009 08:31 AM
Justin Rich

I ran into a strange windows server bug where if you're running sql 2005 cluster on windows server 2008 cluster and node names are in lower case...

Gurmit

10-18-2009 11:21 PM
Gurmit

Hello, I want to migrate a two node Windows Server 2003 x64 R2 Cluster with multiple clustered SQL Server 2008 instances and a few TB of...

Peter Gibbons

10-16-2009 08:16 PM
Peter Gibbons

Hi NG, is there a SQL Server 2005 Best Practices Analyzer for Cluster on market or another official tool wich checks the SQL Cluster Config? thanks...

Thomas Hase

10-11-2009 06:50 AM
Thomas Hase

I'm new to server clustering, and need to implement a SQL Server 2008 cluster. In http://support.microsoft.com/?id=273673 I read that when SQL Server...

Gaspar

10-09-2009 01:24 PM
Russ Kaufmann

We have a SQL 2000 SP3a Active/Passive cluster running on Windows 2003 SP2. We had a failover yesterday. However only the SQL Group failed over,...

RobinMC

10-09-2009 11:44 AM
John Toner [MVP]

I've worked with DB2 clusters in the past. I'm trying to get a good overview of the various layers of setup with SQL Server EE High Availability...

lee

10-09-2009 09:31 AM
lee

Hi Group. We have a cluster with SqlServer 2000. We need to move both databases (master, msdb) to a new disk. Someone knows any paper, link or proce...

rodlop

10-04-2009 09:45 PM
Linchi Shea

We are trying to install a program from a sql cluster. The problem is the install program sees the install coming from the netbios name of the...

Saucer Man

10-04-2009 10:17 AM
Geoff N. Hiten

We have SQL 2000 Active/Passive cluster running on Windows 2003 SP1. I need to apply SP4 but want to minimize downtime. Would the following...

RobinMC

10-02-2009 01:49 PM
RobinMC