Setting up ASE warm standby databases

Setting up databases for a warm standby application involves three high-level tasks. Each of these tasks may include additional 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 do not need to 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.