0
votes
1answer
247 views

SQL Server 2005 SP3 Failover Cluster Node Replacement Service Pack

2-node SQL Server 2005 SP3 (9.0.4226) Failover Cluster running on Windows Server 2003 R2 x64 SP2. My passive node suffered a RAID failure on the OS partition. I evicted the failed node, rebuilt it, ...
3
votes
2answers
136 views

Windows Cluster - Can I failover without disturbing SQL?

I have a 3 node cluster. All of the nodes are part of Cluster01 in what should be A/A/P mode. Usually instanceA and instanceB of SQL Server would reside on NodeA and NodeB respectively. the windows ...
1
vote
1answer
362 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
2
votes
2answers
2k views

How do you setup a SQL 2005 cluster in amazon EC2?

I am trying to setup a highly-available DB architecture in an EC2 servers. We are forced to use SQL 2005 for now. What kind of solutions would work in this context? Has anyone done it? I can't ...
0
votes
2answers
47 views

Is it possible to change a cluster that is dependent on a domain?

Recently we received (2) Poweredge 6850 and (2) PowerVault 220s from our managed server company. These two servers hosted SQL Server 2005 with our SQL database on it. The cluster was dependent on ...
0
votes
1answer
169 views

SQL Server 2005 Service Pack 2 - Failed Cluster Node

We have SQL server 2005 running on our cluster with Service Pack 2. However one of the nodes failed, after rebuilding the node I added the node back to the clster with SQL server setup. However it ...
2
votes
1answer
89 views

Move clustered SQL from one network to another

We have a clustered SQL server (2k5 Std) that's currently being hosted on 1 of 2 subnets on the server. We'd like to retire the subnet the SQL cluster is on as we're experiencing default gateway ...
1
vote
2answers
755 views

Two clustered SQL instances on one cluster - same port 1433?

Can two clustered SQL instances on a 2003 windows cluster use the same 1433 tcp port setting reliably? It seems to be up and working right now.
1
vote
2answers
220 views

Need to reformat SQL Cluster Disk. How do I recover my SQL installation?

We need to reformat the SQL cluster disk in our SQL cluster. The drive contains the shared installation files for SQL as well as databases. My concern is how SQL/The Cluster will react to after we ...
0
votes
1answer
3k views

Configuring Reporting Services SQL Server 2005 in a failover cluster Windows Server 2003

I have the following scenario: Two machines, say NODE1 and NODE2, have Windows Server 2003 installed in a failover cluster, say CLUSTER. On this cluster SQL Server 2005 was installed successfully, ...
0
votes
3answers
867 views

SQL 2005 Active/Active Cluster - Additional Instance Setup

I'm installing a new instance of SQL 2005 on an existing cluster. From what I've read, I should be able to install that new instance on the same cluster name with a new instance name. Same IP, ...
0
votes
1answer
343 views

SQL 2005 cluster to use local storage for backups?

I've built an active/active SQL 2005 cluster using LUNs for SQL, Data, and Logs. Unfortunately, I tried to use local storage (both machines have a local B:) for backups - hey, shared storage is ...
1
vote
1answer
479 views

SQL 2005 Active-Active configuration - Shared Quorum?

I am planning for this scenario: SQL 2005 with an Active/Active configuration (that is, 2 nodes, 2 instances, each node holds active one of the instances, each node is the other's backup) The SQL ...
0
votes
3answers
2k views

Memory settings for multi-instance failover clustering

When using multi-instance failover clustering (used to be called active-active) in SQL Server 2005 and 2008, I'd like to know what you configure the min and max server memory to. For a two-node ...
3
votes
2answers
2k views

Combining failover clustering and database mirroring

When you combine failover clustering and database mirroring in SQL Server, you need to change the mirroring partner timeout value so that the local cluster gets a chance to fail over before database ...