SQL Server Performance Forum – Threads Archive

replication on cluster

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?

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.

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.

Right, probably I was baffled.
Don’t know which type of replication you will choose, refer to books online for setting up REPLICATION topic. For instance refer to this linkhttp://www.databasejournal.com/features/mssql/article.php/1438231 for steps on merge replication. HTH 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.

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.

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.

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

]]>