Setting Up ASE Warm Standby Databases

Setting up databases for a warm standby application involves several high-level tasks.

1. Create a single logical connection that will be used by both the active and standby databases.
2. Use Sybase Central or 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.
3. Use sp_reptostandby or sp_setreptable to enable replication for tables in the active database.
4. Use Sybase Central or rs_init to add the standby database to the replication system, then initialize the standby database.

• Before You Begin
  There are several prerequisites for setting up ASE warm standby databases.
• Task One: Creating the Logical Connection
  Create the logical connection and reconfigure RepAgent for the active database if the active database is already part of the replication system.
• Task Two: Add the Active Database
  Use rs_init to add a database to the replication system as the active database for a warm standby application.
• Task Three: Enabling Replication for Objects in the Active Database
  Use sp_reptostandby to enable replication of stored procedures, and sp_reptostandby or sp_setreptable to enable replication for tables in the active database.
• Task Four: Adding the Standby Database
  Use rs_init to add the standby database and its RepAgent to the replication system, then you initialize the standby database with data from the active database.