SQL Server Performance

replication on cluster

Discussion in 'SQL Server Clustering' started by icata, May 17, 2004.

  1. icata New Member

    Hi,

    At the SQL Server cluster installation I haven't choose the replication component(wasn't required at that time). Now it is and when I run again the setup to modify the installation and to add the replication components it doesn't give me that option. The only option that I have is to uninstall the SQL Server.

    Is it what is suppose to be? If yes how can I install the replication components?
  2. satya Moderator

    If a server you want to include in a cluster uses replication, you need to uninstall replication before adding that server to the cluster. After you have installed the server as part of the cluster, you can reinstall replication on that server.

    SQL Server includes several features that simplify the process of uninstalling and reinstalling replication services. In most cases, you must:

    - Generate replication removal scripts.
    - Generate replication installation scripts.
    - Execute the replication removal scripts on the server.
    - Perform the installation instructions to add the server to the cluster.
    - Perform a search and replace on the installation script using an editor.
    - Replace all old server name references with the new virtual server name references.

    Execute the modified installation scripts.

    Refer to books online about scripting the replication and finally if you decide to drop the replication you can use SP_REMOVDBREPLICATION.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. icata New Member

    I think you got me wrong. I don't have at all replication installed. There are two new servers configured in cluster. When I installed the SQL Server on cluster I haven't choose the replication components. My question is how can I install them later?
    Running SQL Server setup again is giving me the option only to delete.
  4. satya Moderator

  5. icata New Member

    Is not the type of replication that I have problem with, the issue is that I can not create any replication after I installed the SQL Server on the cluster without choosing to install the replication components.

    My question is how I can install the replication components on the SQL Server?
    Running the setup.exe it doesn't seems to work, I got only the option to uninstall.
  6. satya Moderator

    Yes, as I've never managed replication on cluster environment its bit confusing.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. Argyle New Member

    Not sure you are able to do that without unclustering. At least I've never seen any other option than uninstall.

Share This Page