Results 1 to 4 of 4

Thread: SQL Server 2005 Cluster Configuraion

  1. 09-01-2008, 08:48 AM #1
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127

    SQL Server 2005 Cluster Configuraion

    Hi All,

    This is my scenario:

    Server1 - Dev server
    Server2 - Prod 24 by 7
    Server3 - Prod 9 to 5

    If one or both production servers fail, then I'll use dev server for failover.

    What is a proper way of installing SQL Server? Also how these servers should be setup when I look at them in Cluster Administrator? I have read a lot of documentation but I am still not 100% sure.

    Thank you.
    Reply With Quote Reply With Quote
  2. 09-01-2008, 06:35 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You should install 3 seperate instances on the cluster. How many nodes in the cluster?
    Reply With Quote Reply With Quote
  3. 09-01-2008, 06:54 PM #3
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127
    3 nodes , all active.
    Reply With Quote Reply With Quote
  4. 09-02-2008, 03:18 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Then ensure each node has enough horsepower to handle multiple instances in case of failover.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules