Forum Discussion

pgm10s's avatar
pgm10s
Level 5
9 years ago

add node to VCS for SQL

Hello    Currently , I have 2 node cluser for SQL database. There are requirement to add new node to the existing cluster. If I install windows  , sql installation &  configuration as same a...
business continuity
Cluster Server
Windows Server (2003-2008)
  • Wally_Heim's avatar
    Wally_Heim
    9 years ago

    Hi pgm10s,

    It sounds like you have everything covered fairly well.  The installation of SQL needs to have the same path to the binaries as the existing nodes.  The path to the master database files can be different.  But don't worry, the SQL service group configuration wizard will fix that difference.  You just need to run the wizard from an existing node in the cluster where the share storage is already online and then add the new node via the wizard. 

    Be sure to install any SQL patches on the new node that may have been installed on the 2 existing SQL nodes.

    Don't forget to test failover to ensure that SQL is working correctly on all nodes.

    If you have configured SQL Network settings to use a different port then you might need to change that manually.  But if that needs to be done, then it should come out in the testing phase..

    Thank you,

    Wally

Wally_Heim's avatar
Wally_Heim
Level 6
9 years ago

Hi pgm10s,

It sounds like you are on the right track and have a good hand on what you need to do.  Remember that if you have any problems during the process you can always open a case with Symantec Techncial Support.

Thank you,

Wally Hem