If you are downgrading a server in which you have enabled replication on databases that contain encrypted data, you should perform the following steps before you start the downgrade procedure:
Stop all activity in the databases.
Verify that you have successfully transferred all replicated data in the primary database transaction log to the standby or replicate database. The process for doing this depends on the application you are using. See the documentation for your application for more information.
Truncate the transaction log in the primary database:
sp_stop_rep_agent primary_dbname
dbcc settrunc ('ltm', 'ignore')
dump tran primary_dbname with truncate_only
Set the Replication Server locator to zero. Shut down replication server. In the RSSD for the Replication Server, run:
rs_zeroltm primary_servername, primary_dbname
