Setting Up Master Database Replication in a Warm Standby Environment
Set up master database replication in a warm standby environment.
Set up the active master database and the standby
master database in the Replication Server as warm standby pair.
Do
not use “initialize the standby with dump and load” nor “use
the dump marker to start replicating to standby”. To synchronize
the syslogins and suids at
each master, use bcp or manually synchronize
the IDs.
Mark the master database on both the active and the
standby database to send system procedures.
Enter:
sp_reptostandby master, ‘all’
Stop the RepAgent on the active master database.
Enter:
sp_stop_rep_agent master
Configure the Replication Agents on both the active
and the standby databases to send warm standby transactions.