Determine How to Initialize the Standby Database

Initialize the standby database with data from the active database.

See the Adaptive Server Enterprise Reference Manual: Commands.

Replication Server writes an “enable replication” marker into the active database transaction log when you add the standby database using rs_init. Adaptive Server writes a dump marker into the active database transaction log when you perform either a dump database or a dump transaction.

The target database cannot be materialized with dump or load if the database used is the master database. You may use other methodologies such as bcp where the data can be manipulated to resolve inconsistencies.

• Summary of Database Initialization Methods
  Consider the issues for each of the initialization methods and the role of these markers.
• Cross-Platform Dump and Load
  You can use cross-platform dump and load to initialize a standby database with a RepAgent.
• If You Do Not Suspend Transaction Processing
  If you do not suspend transaction processing for the active database while initializing the standby database, choose the “dump marker” option when you add the standby database.
• If You Suspend Transaction Processing
  If you suspend transaction processing for the active database while initializing the standby database, do not choose the “dump marker” option when you add the standby database.