Setting Up Master Database Replication in a Warm Standby Environment

Set up master database replication in a warm standby environment.

1. 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.

2. Mark the master database on both the active and the standby database to send system procedures.
   Enter:

   sp_reptostandby master, ‘all’

3. Stop the RepAgent on the active master database.
   Enter:

   sp_stop_rep_agent master

4. Configure the Replication Agents on both the active and the standby databases to send warm standby transactions.
   Enter:

   sp_config_rep_agent master, ‘send warm standby
   xacts’, ‘true’

5. Restart the RepAgent on the active master database.
   Enter:

   sp_start_rep_agent master

6. Resume the DSI connections to both the active and the standby master databases on the Replication Server.
   Enter:

   resume connection to active_ds.master
   go
   resume connection to standby_ds.master
   go

7. Verify the status of warm standby.
   Enter:

   admin logical_status