4
votes
2answers
540 views

SQL Clustering or Hyper V Clustering

We will soon be implementing our Dynamics AX installation. Our aim is to have high availability and we are working closely with our implementers. We raised the question to them about SQL and Hyper-V ...
0
votes
2answers
40 views

using multiple schemes in a clustered sql server 2008 Database

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
0
votes
0answers
40 views

Re-Ask - why would adding a crossover private nic cause IP address resource fail? [duplicate]

Possible Duplicate: why would adding a crossover private nic cause IP address resource fail? 2 node Win 2008 R2 quorum cluster Configured 192.168.0.0/24 "public network" Configured cluster ...
2
votes
2answers
475 views

why would adding a crossover private nic cause IP address resource fail?

2 node Win 2008 R2 quorum cluster Configured 192.168.0.0/24 "public network" Configured cluster MSDTC Installed SQL 2008 R2 cluster instance Manually failover groups - OK Reboot server w/o failing ...
1
vote
1answer
63 views

Manaul SQL cluster failover on 2008R2

I need to do a restart of the clustered SQL instance to fix a problem with tempDB and i am not sure of the easiest way to do this. We have just upgraded our servers to Windows 2008R2 running SQL ...
1
vote
1answer
419 views

Lost Clustered disk in Windows 2008 R1 SQL Cluster

I currently am running a 2008 R1 64 bit cluster. Last night I get called by our first tier support that we have a failed cluster disk. At 5PM we received the following error: Cluster physical ...
3
votes
2answers
150 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
197 views

Addressing SQL 2008 mirror cluster

Hallo SQL jedis, I want my database to be always available. So I've set up database mirroring, which is working peachy. My question though, is how can I consistently address the database? I want ...
0
votes
1answer
84 views

Distributed Microsoft SQL server deployment - Cluster?

I have a website, I want to host on two diffident very far deployments. I have a rather good connection between them. But the users have a good connection only to what's near them. My Idea is to ...
0
votes
3answers
169 views

sql server 2 node cluster - different apps on different nodes

I've got a 2-node SQL Server cluster (SQL 2008 sp1) running on Windows Server 2008 R2. It's an active/passive cluster and currently, node1 is the active node. There is an app running on node1. I've ...
1
vote
3answers
144 views

High Availability on SQL Server (Suggestions)

We have a database intensive Java application. The DB we use is SQL Server 2008. We are thinking of shifting our Java application to a 2-3 node load-balancing cluster. We have frequent application ...
0
votes
3answers
271 views

SQL Cluster 2008 and iSCSI

what's your experience with iSCSI and SQL Cluster setup's? We bought HP StorageWorks MSA2324i. We'll place our high-volume transaction processing system on it.
1
vote
1answer
204 views

Run a script prior to start of SQL instance via Windows clusters

We have a Windows 2008 cluster with several SQL 2008 instance. We would like to run a script that modifies 4 registry keys prior to the startup of SQL. I do not know if there is a way to have a ...
0
votes
1answer
90 views

Can I use 1 Shared Storage for Multiple Windows 2003 Clusters?

My Environment: Dell PowerVault 220S connected via SCSI to 2 Dell Poweredge 2950s. I have installed ESX 4i on each of the 2950s, and do NOT have VCenter. I will be using Windows Server 2003 ...