Changing primary databases to replicate databases

If you want to change a primary database to a replicate database, use the following procedure:

• Drop all subscriptions and publication subscriptions to the replication definitions in this database.

• Drop all replication definitions defined for this database.

1. Shut down RepAgent:

   sp_stop_rep_agent dbname
   

2. Disable RepAgent:

   sp_config_rep_agent dbname, disable
   

• Log in to the Replication Server that manages the database and execute alter connection using the log transfer off option:

  alter connection to data_server.database
  set log transfer off
  

1. Set the status of rs_marker to “false:”

   sp_setreplicate rs_marker, 'false'
   

2. Set the replicate status of all replicated objects to “false”:

   1. Execute sp_setreptable without arguments to generate a list of all replicated tables and stored procedures in the database.

   2. One by one, set the replicate status of each table and stored procedure to “false,” using sp_setreptable and sp_setrepproc.