• Clustering in SQL Server 2005

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

    ScorpionSQL10 pointsBadges:
  • Behaviour of Service Broker during clustered SQL Server failover

    Hi, I have 3 instances of SQL Server 2005 hosted on a 3-node cluster, using Polyserve clustering.  Each instance is nominally hosted on its own node in the cluster. I have configured Service Broker to route messages from INST-A (on NODE-1) to INST-C (on NODE-3), using TCP and a NetBIOS name....

    SimonNZ5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating second instance on SQL Server 2008 cluster

    Hi, I need help to create second instance on SQL 2008 Cluster. I have active/passive Windows 2008 R2 cluster and currently using a default instance of SQL. Most of the blogs mention that installation of new instance is same as the first one and you need to provide IP, network-name and disk...

    PowerEdge5 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • load balancing in sql server

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

    Rabinarayan5 pointsBadges:
  • cluster install node failure when adding

    I installed a sql server 2008 cluster, first node went fine, however the 2nd node install fails with the following installing failover node sql server 2008 This resource does not have all the nodes of the cluster listed as 'Possible Owners'. The group that this resource is a member of will not be...

    tcstl95 pointsBadges:
  • SQL Server Fails to Start When Moved to Different Node

    Sql 2008 R2 on Windows 2008 R2 cluster. When I move instance from node 1 to node 2 everything is fine: all resources come online as they should. When I move the instance from node 2 to node 1, all resources except sql server and agent come online. If I delete errorlog and start the sql server...

    Spadasoe5,130 pointsBadges:
  • How to move sql server clustered instance to a separate stand alone server

    We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a...

    Sqlserver2008r25 pointsBadges:
  • Add an Active node to SQL Server Active Passive Cluster

    how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

    Jasina30 pointsBadges:
  • SQL Server 2005 & 2008 on a Cluster in Production

    Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

    Lorisj3325 pointsBadges:
  • Upgrade SQL 2005 Cluster to SQL 2008

    We have a remote sql 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for sql 2008. If I build an active/passive cluster with sql 2005 on Windows 2008, is there the ability to upgrade the sql server to a SQL 2008...

    tcstl95 pointsBadges:
  • SQL Server 2005: Improving performance of Multiple Databases & LUNS

    I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as they are...

    Bulldog9815 pointsBadges:
  • 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?

    DbaDave25 pointsBadges:
  • 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 the...

    Sabi1330 pointsBadges:
  • 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...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Multiple instances with SQL Server

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

    IMR5 pointsBadges:
  • Federated Fabric cluster

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

    Henrywat4885 pointsBadges:
  • 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 ??

    Gazzer5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following