Use the following procedure to change a primary database to a replicate database:
Drop all subscriptions to the replication definitions in this database.
Drop all replication definitions and functions defined for this database.
Shut down the LTM.
Log in to the Replication Server that manages the database and execute the alter connection command using the log transfer off option:
alter connection to data_server.database set log transfer off
Log in to the SQL Server and set the LTM truncation point for the database to “ignore”:
use database
go
dbcc settrunc('ltm', 'ignore')
go
Set the status of rs_marker to “false” using the sp_setrepproc system procedure.
sp_setrepproc rs_marker, 'false'
Set the replicate status of all replicated objects to “false”. To do this:
Execute sp_setreptable and sp_setrepproc without any arguments to generate a list of all replicated tables and stored procedures in the database.
One by one, set the replicate status of each table and stored procedure to “false,” using sp_setreptable and sp_setrepproc.
