We have a 2-node Server 2003 SP1 cluster with SQL 2005 SP1. We had a series of power outages, and, the "B" node was damaged and won't run the...

Bill Bradley

04-18-2008 12:30 PM
Geoff N. Hiten

We are looking to create an Active/Passive cluster with two named instances. In this scenario, would the data files associated with the...

cwallace5150

04-18-2008 11:37 AM
Linchi Shea

Is a failover logged in Cluster.log? If so, what text would be recorded? Thank you. -- Mike

Mike

04-18-2008 09:55 AM
Mike

In Cluster Administrator, when you "Move Group" from node A to node B in a active/passive cluster, what log is this recorded in, and what would...

Mike

04-17-2008 05:38 PM
Mike

I have a two node active/active cluster setup. when i stop the cluster service one node A all resources fail over to the other node B, but the...

Darren

04-16-2008 08:01 PM
Darren

Greetings all, We need some help understanding our options. We have a 64bit W2003 SP2 & SQL 2005 SP2 currently running as a single instance. We...

Pearl

04-16-2008 04:41 PM
Geoff N. Hiten

Hello, I'm attempting to add three nodes to a SQL 2000 two node cluster. All three servers have been added but I cannot failover the sql instances...

AJ

04-16-2008 04:38 PM
Geoff N. Hiten

Does anyone have a kb article on how to restore the master database in a sql 2005 cluster?

SQLdba

04-16-2008 01:50 PM
SQLdba

Hi, basically I want to do a proof of concept and get used to setting up clustering. I am ready to buy 4 cheap boxes and have 2 for the cluster...

Cluster Beginner

04-16-2008 11:28 AM
Linchi Shea

I have a active/passive clustered SQL Server 2005 Enterprise. If the data file becomes corrupt, I've lost my high availability and because the...

Curtis Morrison

04-15-2008 01:16 PM
Geoff N. Hiten

All, Here is the Scenario. A\A cluster DB mirroring is enabled for both the nodes to 2 stand alone servers. In the second node the...

Manoj Kumar

04-12-2008 02:24 PM
Manoj Kumar

Hello, I am consilidating my SQL servers and wanted to get recommedation for consolidating 15 Servers that are all 3.5 GB Memmory,CPU utilization...

Lontae Jones

04-11-2008 09:54 PM
Linchi Shea

Hello, We currently have an Active/Active SQL 2000 setup. I'm in the process of adding 3 more nodes to the cluster. The problem I'm having is when...

AJ

04-11-2008 04:23 PM
Russ Kaufmann [MSFT]

Basically, we have a 24/7 database on the MS SQL 2005 cluster. Last week, the cluster failed due to the NIC fault. The service was stopped for almost...

LanLan

04-11-2008 01:32 PM
Geoff N. Hiten

Has anyone seen a sql 2005 cluster with very high wnilogon.exe processes? The passive node has a winlogon.exe using 2gb of ram, and the active...

DaveGunther

04-10-2008 09:41 AM
Nirmal Sharma

Are there any reasons why the SQL Server Service of an SQL Server 2005 Cluster (active/passive), should not be restarted using Management Studio? Is...

Sean Snider

04-09-2008 05:58 PM
Sanjaya Padhi

Hi Guys, Any idea where SQL Setup get parameters writen to the sqlsetup...datastore.xml ? I've got a wrong value in Sqldataroot property. Thanks in...

Jerome Bastide

04-08-2008 08:48 PM
Sanjaya Padhi

According to the sp2 readme: 3.2.5 Installing SQL Server 2005 SP2 on a Failover Cluster Instance Note the following information before you install...

geekyguy

04-07-2008 10:34 AM
Jane Doe Simmons

I have a vendor telling me that I need the Enterprise version of SQL 2005 in order to run an active/active cluster and that I can only run...

Tim J

04-06-2008 05:11 PM
Aleksandar Grbic

Server Environment: N + 1 (Four Nodes), IBM X-Series, 32-bit, 4 processors, 16 GB RAM SQL 2000, SP4 with hotfixes, AWE and PAE configured The SQL...

edsmith@pascocountyfl.net

04-04-2008 03:54 PM
edsmith@pascocountyfl.net

Hi All: I've read the support page for installing sp2 on a cluster, but I'm just wondering if there are any other "gotchas" that aren't covered...

geek-y-guy

03-31-2008 12:52 PM
Kevin3NF

I'm trying to boost SQL server 2000's speed at running some of my long queries.Is it a good idea to put the tempDB on a physically separate...

Leon McCalla

03-30-2008 02:54 PM
Andrew J. Kelly

Hi, From what I have read, SQL Server is per se not fault tolerant. In other words, in a two node instance should one node fail the transactions...

Steve Kitley

03-29-2008 05:20 AM
Riccardone

We are running an active/active SQL Server cluster with 4 named instances of SQL Server 2000. We run 2 instances on each cluster node. We would...

irene

03-28-2008 01:13 PM
Riccardone

Hello, Can someone share some documetation for setting up SQL 2003 failover server that is across a WAN on a VPN ? Thanks Joe

Tony

03-27-2008 03:42 PM
Russ Kaufmann [MVP]

Hello, Is it possible to run both SQL and Exchange on a MS Cluster environment? We're considering purchasing a new SQL Cluster (Active/Active) and...

Troy Bruder

03-27-2008 03:38 PM
Russ Kaufmann [MVP]

Hi to all. When i try to run Best Practices Analyzer against a SQL 2005 instance running as a cluster resource in a cluster node I get: "Skipping...

Antonio Barbosa

03-27-2008 07:11 AM
Antonio Barbosa

Hello, Can someone please share with me documentation for setting up SQL 2003 Cluster Failover to a SQL Server over a WAN on a VPN...

cap7@nospam.com

03-26-2008 03:27 PM
cap7@nospam.com

We have a 64 bit SQL Server 2005 Cluster (Active/Passive) that was upgraded from a 32 bit SQL 2000 Server. Our cluster is not yet running Service...

Sean Snider

03-24-2008 10:17 PM
Linchi Shea

we have been reviewing the possibilities of scale-out technology such as data partitioning, federated servers, peer to peer repl, clustering,...

Chris

03-24-2008 10:13 PM
Linchi Shea

Howdy. I'm running an Active/Active cluster on a SQL Server 2005 cluster. Both have identical hardware, and obviously the same disks. One really...

M Bourgon

03-24-2008 01:18 PM
Tom Moreau

I am reading how to install SQL 2005 in a clustered environment from a text book and have never done it personally myself. When you reach the...

Rubens

03-23-2008 08:11 PM
Rubens

Hi, We have two production SQL Server 2005 clusters. The one (the old) cluster is member of its own domain, called SQL-CLUSTER. The other cluster...

Henrik Davidsen

03-22-2008 06:27 PM
Henrik Davidsen

Hello, I have been working on a 2 node cluster W2k3 EE R2 x64 2 indentical servers on a brand new SAN. In my reading I have found that I need two...

mjerikboo777

03-20-2008 03:25 PM
MJboo

Hi Folks, We are running SQL Server 2005 Cluster enviornment with single instance-two node configuration. Presently both servers have 4GB ram,...

Mohit K. Gupta

03-18-2008 12:54 PM
Mohit K. Gupta

I'm troubleshooting a related problem, and was hoping someone could give me a complete list of the resources installed for SQl2005 a/p clustering,...

Bill P

03-18-2008 08:38 AM
MJboo

Can I install SQL 2005, and Analysis and Reporting services all in the same cluster? No, I don't care whether it is advisable, just whether it can...

Russ Kaufmann [MVP]

03-18-2008 08:20 AM
MJboo

We have our production SQL 2005 server (64 bit Standard Ed.) attached to an iSCSI Equalogic SAN. We have set up 2 new servers an installed the...

Carlos

03-14-2008 11:37 PM
Linchi Shea

Hi, We are hosting an ASP.NET web application in a Windows 2003 server (with SP 2) that talks to an SQL Server 2000 database in another machine -...

jeevanjyoti

03-14-2008 11:41 AM
jeevanjyoti

In the first runs of installing SQL Server 2005 on a cluster, we needed to use domain groups for each service as part of the install. It was...

frankm

03-13-2008 12:36 PM
frankm

I the first runs of installing SQL Server 2005 on a cluster, we needed to use domain groups for each service as part of the install. It was...

frankm

03-13-2008 12:05 PM
frankm

Hello, Not sure I have posted this in the correct discussion group. I am looking for documentation: how to load balance across two Analysis Services...

FredG

03-11-2008 03:08 PM
FredG

We have an SQL Cluster active/passive, currently running SQL 2005 as a named instance. We want to now install SQL 2000 as the default instance. ...

Will Jackson

03-11-2008 02:57 PM
Tom Moreau

I have 1 sql 2000 cluster (2 nodes active/passive) running on win2k3. I have one default instance running. I need to create a separate instance. Do...

JR

03-10-2008 08:55 AM
Geoff N. Hiten

Hello folks We have SQL Server 2005 (64 bit)(SP2) clustering (Active/Active) installed on Windows 2003 64 bit One node/instance has different...

Alex

03-10-2008 01:32 AM
Alex

I have a 2 node-WIN2K3 EE x64 R2 Cluster and that's working fine. In the past I installed SQL Server on it & that installation died for some problem...

w2k3e_install

03-09-2008 06:08 PM
w2k3e_install

Greetings, I've been asked to try and take our first foray into setting up a SQL 2005 Active/Passive cluster for a SharePoint deployment. I've not...

Armando

03-07-2008 09:42 PM
Linchi Shea

Hello all, I wish to ask two questions about failover (active/passive) SQL 2005 clustering, as some parts are vague about these matters from what I...

Christos

03-07-2008 03:32 AM
Christos

Please forgive the cross posting. I just don't know which would be the right group for this quesions. We are looking at using Business Contact...

M.Siler

03-06-2008 09:45 AM
M.Siler

OS: Windows Server 2003 SQL Server: SQL Server 2000 Enterprise Edition Environment: Development Summary: 2 node Windows cluster has been (verified...

mj

03-06-2008 09:16 AM
mj