Consider these restrictions and requirements when you set up your warm standby application and enable replication with sp_reptostandby.
Both the active and standby databases must be managed by Adaptive Servers and must support RepAgent. Both databases must have the same disk allocations, segment names, and roles. See the Adaptive Server Enterprise System Administration Guide.
The active database name must exist in the standby server. Otherwise, replication of commands or procedures containing the name of that database fails.
Replication Server does not support replication of DDL commands containing local variables. You must explicitly define site-specific information for these commands.
Login information is not replicated to the standby database. Make the server user's IDs match, and add login information to the destination Replication Server.
A REQUEST transaction to database '...' failed because the transaction owner's password is missing. This prevents the preservation of transaction ownership.