When Warm Standby Involves a Replicate Database

You can copy information from an active database to a standby database and also copy information from the active database to a replicate database.

Replication Server must copy the text, unitext, image, and rawobject columns of the table to the standby and replicate databases with the same replication status.

Do not change the replication status for the table if you want to copy all text, unitext, image, and rawobject columns to the standby and replicate databases. By default, all text, unitext, image, and rawobject columns are copied to standby and replicate databases.

To copy only text, unitext, image, and rawobject columns that have changed, use sp_setrepcol to set the replication status to replicate_if_changed.