Setting up databases for a warm standby application involves
several high-level tasks.
- Create a single logical
connection that will be used by both the active and standby databases.
- Use rs_init to add the active database to the
replication system.
You need not
add the active database if you have designated as the active
database a database that was previously added to the replication
system.
- Use sp_reptostandby or sp_setreptable to
enable replication for tables in the active database.
- Use rs_init to add the standby database to
the replication system, then initialize the standby database.