Results 1 to 4 of 4

Thread: clustering an existing instance of sql 2000

  1. 01-15-2007, 04:23 PM #1
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261

    clustering an existing instance of sql 2000

    We have a client running a 3rd party app on sql 2000 Enterprise on Windows 2003 Advanced attached to a new SAN. They are looking at adding another SQL server and clustering for failover. Anyone done this before. Do you have to reninstall sql server on the original box to do this. This a a heavily used app, so downtime is always an issue.
    Reply With Quote Reply With Quote
  2. 01-15-2007, 05:37 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can build a new sql cluster then move the db and app over.
    Reply With Quote Reply With Quote
  3. 01-15-2007, 05:38 PM #3
    timc
    timc is offline Registered User
    Join Date
    Nov 2002
    Posts
    261
    Are you saying create a cluster on the 2nd server and then add the old one?
    Reply With Quote Reply With Quote
  4. 01-15-2007, 07:23 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    No, you need two servers to build cluster. You can use existing server, but expect down time during cluster build.
    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