SQL Server Clustering Questions and Answers

Recent IT Questions

1 - 19 of 19
<<PREVIOUS 1 NEXT>>

SAP SQL database cluster

Hi Our sap configuration include two nodes on win 2003 cluster/ The cluster using us for SQL 2005 . I need to upgrade the hardware. It is possible to add two new nodes to the cluster ? It is downtime necessary if i want to replace one of the nodes ? it possible to install the sap software when...

asked by Sabi13

  30 pts.

How many tempdb's necessary in our clustered environment?

We have a clustered environment with three nodes and five instances. Each node has eight CPU's, and we are wondering how many tempdb's are necessary for each instance. Do you do the calculation on the total number of CPU's, all 5 instances failed over to one node or some other variation that I...

View Answer   |  Mar 9 2009  6:18 PM GMT
TempDBs, Clustered servers, SQL Server clustering
asked by SQL Server Ask the Experts

  2445 pts.

Removing a node from a working SQL Server 2005 cluster

I have Windows Server 2003 with SQL Server 2005 Standard Edition. We have seven divided instances, with each using only two of the three nodes. However, node one has to be taken out of the cluster; what steps should be taken to insure no significant loss in performance?

asked by SQL Server Ask the Experts

  2445 pts.

Multiple instances with SQL Server

Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

asked by IMR

  5 pts.

cluster

what's the steps to use ( Clustering ) in any SQL Server 2005 System??

View Answer   |  Nov 26 2008  2:36 PM GMT
Database, SQL Server clustering, SQL Server 2005
asked by ScorpionSQL

  10 pts.

Virtualizing a SQL Server cluster in a production environment

What is Microsoft's official position in using virtualization (Virtual servers such as VMWare, etc.) for a SQL Server cluster (two node Active Passive) in a production environment? What are the best practices?

View Answer   |  Nov 7 2008  3:34 PM GMT
Virtualization, SQL Server, SQL Server clustering
asked by SQL Server Ask the Experts

  2445 pts.

Federated Fabric cluster

Can any one help me out on how to setup a federated fabric cluster using SQL 2005 + windows 2003

asked by Henrywat488

  5 pts.

Upgrading clustered SQL 2005 64 bit standard to enterprise

Does anyone have any steps on how to upgrade a clustered SQL 2005 64 bit standard edition to a clustered 64 bit enterprise edition ??

asked by Gazzer

  5 pts.

Clustering in SQL Server 2005/Windows Server 2003

Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

asked by SQL Server Ask the Experts

  2445 pts.

Command to display virtual nodes hosted by a physical server.

We have a four node (N+1)SQL 2005 cluster. From a DOS prompt, is there a command that can be run on each of the physical servers that will show you if it is hosting one of the virtual nodes of the cluster?

View Answer   |  Aug 20 2008  1:37 PM GMT
SQL Server clustering, SQL Server 2005
asked by JohnGalt

  35 pts.

Setting up failover notifications in SQL Server 2005 cluster

We are new to clustering. We have recently successfully implemented a four-node (active/passive config) SQL Server 2005 cluster. How can I be automatically notified when a node within the cluster fails over to the passive standby or other node within the cluster? Thanks, JGalt

View Answer   |  Aug 20 2008  1:20 PM GMT
SQL Server clustering, SQL Server 2005
asked by JohnGalt

  35 pts.

clustered sql 2000 to sql 2005 upgrade

What can I expect when upgrading a clustered SQL 2000 box to SQL 2005?

View Answer   |  Jun 24 2008  9:41 PM GMT
SQL Server clustering, SQL Server upgrades, SQL 2005
asked by Ajf

  10 pts.

Can SQL Server 2005 32-bit and SQL Server 2005 64-bit co-exist on the same cluster machine?

Can SQL Server 2005 32 bit and SQL Server 2005 64 bit co-exist on the same cluster machine?

asked by SQL Server Ask the Experts

  2445 pts.

How to install a passive node on an active/active SQL Server cluster

We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. ...

asked by SQL Server Ask the Experts

  2445 pts.

What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?

What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?

View Answer   |  Apr 30 2008  5:23 PM GMT
Windows Server 2003, Clusters, SQL Server clustering
asked by SQL Server Ask the Experts

  2445 pts.

load balancing in sql server

Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

View Answer   |  Apr 28 2008  11:08 AM GMT
SQL Server, Load balancing, SQL Server clustering
asked by Rabinarayan

  5 pts.

SQL 2005 Active/Active/Passive

We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. ...

View Answer   |  Apr 23 2008  6:23 PM GMT
SQL, SQL Server clustering, SQL Server 2005
asked by Kjrichmond

  15 pts.

SQL Server 2005 multi-instance cluster

I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?

asked by DbaDave2

  5 pts.

Using Veritas for SQL clustering

I would like to know if anyone is using VCS for SQL clustering and, if so, what their real-world experiences and thoughts are on VCS versus Microsoft SQL Clustering.

View Answer   |  Feb 12 2008  7:20 PM GMT
SQL Server clustering, VCS, MSSC
asked by JohnGalt

  35 pts.

1 - 19 of 19
<<PREVIOUS 1 NEXT>>