I have a 2 node (A/P) SQL Server 2005 cluster setup with a disk resource solely used for backup process. This resource is currently a dependency...

AJ

09-30-2009 11:27 PM
Geoff N. Hiten

We're planning to setup a 2-node (i.e. Node1 & Node2) cluster to host 4 SQL Server DBs attached to SAN (J: Drive) The default scenario is to make J:...

Joseph

09-30-2009 09:02 AM
Geoff N. Hiten

Hi All, I have the following scenario: I have SQL 2005 Standard (x64) installed on 2 nodes (Active/Passive) on Windows 2003 (x64). There is a...

Ravi Kumar

09-30-2009 09:00 AM
Geoff N. Hiten

Hi, Installing sp3 on 4 nodes in clustering, installation go in success on 1 node but not is applied on other nodes (I have domain admins...

Emilio Claudio Sgambelluri

09-29-2009 06:27 AM
Emilio Claudio Sgambelluri

Hi, I am developing an SSIS based solution that utilizes logic in a custom .Net assembly which is referenced from SSIS packages. Our current...

Scott Munro

09-29-2009 04:22 AM
Scott Munro

I am planning on a two node SQL 2008 cluster but will not be ready to install the cluster for a few weeks. Is it possible to install the...

Go Oilers

09-28-2009 03:53 PM
Geoff N. Hiten

Hi All I have an older machine which has SQL 2000 Sp3 running on a Windows 2000 Cluster. I am going to apply SP4 tonite. My question is, I have done...

Nik

09-27-2009 11:06 AM
Geoff N. Hiten

I have Server 2008 Enterprise running on two virtual machines, running on a VMWare ESXi system, with shared disks required all set up. The...

TimS

09-21-2009 03:21 PM
TimS

Proposed designed architecture We are developing a website with following details: The basic functionality of the site is 1. The website has two...

Shamshad Ali

09-18-2009 06:22 AM
Shamshad Ali

Hello everyone, While installing an active active 2 node cluster with 2 instances I finally realised that its going to be a lengthy process. 1. You...

VBeachcomber

09-14-2009 09:20 PM
Russ Kaufmann

Gurus, Running SQL Server 2005 SP2 on a cluster (two Windows Server 2003 SP2 nodes, SQL instance running on each, active/active design). A hardware...

Spin

09-12-2009 12:54 PM
Jeffrey Williams

I run an active/passive SQL 2005 cluster (Svc Pk 2, soon 3) on Windows Svr 2003 (Svc Pk 2). Our most recent round of operating system patches seems...

Doug

09-10-2009 04:25 PM
LaRoux

Hi, I have an issues where the sql agent does not automatically when sql server is moved (failover) from one node to the other. If I wait 5-10...

Gunno

09-10-2009 03:13 PM
Linchi Shea

Ajay Rengunthwar

09-08-2009 11:18 PM
Ajay Rengunthwar

I have two separate SQL Clusters which I need to automate restoring one database from Cluster A to Cluster B. The database on Cluster A has a daily...

Robin9876

09-03-2009 12:31 PM
Linchi Shea

Boe

09-02-2009 10:20 PM
Boe

How do I add a new instance to an existing 2 node cluster? I have two Server 2008 nodes supporting 2 clusters (active/active); cluster1 running as...

BMarxhausen

09-02-2009 09:51 PM
Geoff N. Hiten

The Setup: Windows Server 2003 Enterprise SP2 7GB RAM SQL Server 2000 SP4 + AWE Hotfix 2 Node cluster Active/Passive 10 SQL Instances Running The...

Scott

09-02-2009 07:43 AM
Scott

Hi , I would appreciate if someone could provide some clarity around this issue: I have installed SQL on Clusters and in the Application server I...

Gokul Rajan

09-01-2009 11:57 AM
Gokul Rajan

Hello Folks, I've a windows 2008 cluster and I recently installed SQL 2008 Failover clustering. After installing I realized that the SQL Network...

VBeachcomber

08-28-2009 12:56 PM
daveberm

We have been having a strange problem. We have been attempting to install SQL Server 2005 Enterprise Edition on a two-node cluster. The install...

Loren Z

08-26-2009 03:45 PM
Loren Z

Need I make my clustered instance of SQL2K8 (on W2K8) dependent on the mounted drives where its data lives, or on only those drives' parent?

Robert Hindla

08-26-2009 02:33 PM
Geoff N. Hiten

In KB958734 "SQL Server 2008 failover cluster rolling patch and service pack process" it tells us to use "the Cluster Administrator tool...

Ron

08-26-2009 02:31 PM
Geoff N. Hiten

I have installed sql 2008 ent in win 2008 cluster. i finish the install to first node and istance it's All ok, i add second node and the install all...

Alexmela

08-26-2009 06:44 AM
Alexmela

We have a Win 2003 EE X64 cluster and installed Sql svr 2008 , we can't get the SQL Network Name up and online, it keeps failing. we get the...

criechton

08-24-2009 12:57 PM
criechton

I recently upgrade test SQL server 2005 from SP2 3315 to SP3. The logs shows the installation was successful and also when I see the Add remove...

ittech

08-21-2009 11:42 AM
ittech

Hi all, I have a three way SQL 2005 x64 Enterprise cluster (running on Windows 2003 x64 Enterprise). The hardware that I am using is HP Proliant 380...

Adam Przestroga

08-20-2009 06:19 PM
Adam Przestroga

Hi All, I've been working on a cluster design (n+1) for server consolidation on a service environment. One node will host a single sql server...

Ada

08-19-2009 12:04 AM
Ada

I am attempting to install 64 bit SQL Server 2005 on a two node Windows Server 2008 SP2 cluster. I get to the part of the install "Remote...

Loren Z

08-18-2009 01:32 PM
Loren Z

Hi My server environment - Windows Server 2003 SP2 and SQL Server 2005 Standard Editon with SP2 while installing the SQL Server 2005 SP3 the setup...

Surendra Kavali

08-11-2009 02:06 AM
Surendra Kavali

I'm setting up my first cluster (SQL Server 2005 on Windows 2008) and need advice regarding MSDTC (Microsoft Distributed Transaction coordinator)....

robd08

08-10-2009 01:33 AM
Manpreet Singh

SQL server SP2 Mirroring with auto failover. Everything looks fine except: Login account, SQL service domain Account with local Admin rights. on...

EX Admin

08-05-2009 04:35 PM
EX Admin

I just wanted to ask someone if wha I have so far was correct. I set 2 Virtual Win 2k8 servers with iscsi connections to the same 100G disk, I...

Tbaker

08-05-2009 02:53 PM
Geoff N. Hiten

Gurus, Running SQL Server 2005 SP2 on a cluster (two nodes, SQL instance running on each, active/active design). Our network team recently forced...

Spin

08-04-2009 02:23 AM
Pluto

Hi all, I have SQL 2005 Ent SP3 clustered running on Windows 2003 Ent SP2 attached to SCSI HP DAS MSA500. I would like to migrate these servers to...

Pluto

08-03-2009 06:45 AM
Pluto

Hi. I have a windows 2008 cluster configured and also have the SQL server and the SQL server agent service configured inside the cluster. In the...

Riz

07-29-2009 08:29 AM
Geoff N. Hiten

That error message is correct. You must take the SQL Server resource offline to change its dependencies. -- Geoff N. Hiten Microsoft SQL Server...

Tom Moreau

07-27-2009 04:22 PM
Geoff N. Hiten

Hi, I have just built a three way - three node (active\active\active) analysis server cluster. I would like to configure each analysis server to run...

Martin

07-27-2009 02:55 AM
Martin

The installation is progressing, however, it's failing in new and exciting ways. I'm encountering two different errors in my System Event...

drew.flint@gmail.com

07-24-2009 08:35 AM
drew.flint@gmail.com

I have a 2-node Windows 2003/SQL 2008 cluster with multiple instances, and I want to add SSAS to one of the instances. When I run the installer with...

Ryan McCauley

07-22-2009 11:00 AM
Ryan McCauley

I wonder if my interpretation of the "offline" status given (in diskmgmt.msc) to a drive just added to a W2K8-based SQL cluster is correct. Let's...

Robert Hindla

07-22-2009 02:10 AM
Russ Kaufmann

Hi there I've seen antivirus software wreck clusters before but normally it took less than 24 hours to kill the cluster... A client has a (now dead)...

Kinch

07-21-2009 10:21 AM
Kinch

I'm trying to setup a SQL 2008 Cluster on a Windows 2008 Failover Cluster. I'm going through the SQL Server Failover Cluster instance setup wizard. I...

drew.flint@gmail.com

07-21-2009 10:00 AM
drew.flint@gmail.com

Hi Guys I want do install the Microsoft SQL Server 2005 Backward Compatibility Components“ (SQLServer2005_BC.msi)on my SQL 2008 SP1 Cluster. Now...

Stefan Mitterbuchner

07-21-2009 02:17 AM
Stefan Mitterbuchner

I wonder if my interpretation of the "offline" status given (in diskmgmt.msc) to a drive just added to a W2K8-based SQL cluster is correct. Let's...

Robert Hindla

07-20-2009 05:24 PM
John Toner [MVP]

Hello Everyone, I'm trying to setup a 2 node SQL 2008 failover cluster in windows 2008 (2 instances). After reading some documentation, I'm...

John

07-16-2009 04:52 PM
John

I got the following error below while trying to take my database ofline Error occurred while attempting to drop worktable with partition...

SyNEttech

07-13-2009 02:53 AM
Charles Wang [MSFT]

Hi, I am having two instance in a SQL 2008 / Win 2008. In this case do I have to have two MSDTC resource groups in the cluster? Thanks, Gunter

Gunno

07-08-2009 09:04 AM
Geoff N. Hiten

My company will buy 2 servers + 1cluster for storage SQL. I need buy SQL 2008 standard or enterprise edition suitable for cluster? Thanks!

I uninstalled Windows internal database

07-08-2009 02:52 AM
Tibor Karaszi

No. The virtualservername/instancename is the namespace that has to have uniqueness. Simply put, if they two servers/instances can exist on the...

Geoff N. Hiten

07-07-2009 12:18 PM
Geoff N. Hiten