HOME

To remove and add server to a replication system and it is working fine


Run these commands at all RSSDs to keep the back up of all the tables

select * into rs_databases_back from rs_databases
select * into rs_idnames_back from rs_idnames
select * into rs_maintusers_back from rs_maintusers
select * into rs_subscriptions_back from rs_subscriptions

Back up tables are
rs_subscriptions_back, rs_databases_back, rs_idnames_back, rs_maintusers_back
the above steps are done before cp2 is run by the installation wizard.

Steps used to delete a server from the replication system�
1. delete from rs_subscriptions where dbid=
2. drop connection to GODAVARI.cp2db run at Primary RepServer

Steps used when new server joins the replication setup..
1. insert into rs_databases select * from rs_databases_back where dsname=''
2. insert into rs_idnames select * from rs_idnames_back where name1=''
3. insert into rs_maintusers select * from rs_maintusers_back where destid=
4 insert into rs_subscriptions select * from rs_subscriptions_back where dbid=
5. run the commands sysadmin hibernate_on, purge the queue of the server a,resume connection to .cp2db and sysadmin hibernate_off
6. run sp_start_rep_agent cp2db at primary database

HOME

1