Sometimes it is necessary to resync the warm standby replication. This could be due to an error, or if replication definitions need to be changed, like changing replication behavior for text and image columns.
In this case the steps to resync…
The following commands are being used to check the health of the replication system.
isql -Usa -P -S >admin who_is_down >go
Everything is OK if no rows are returned.
isql -Usa -P -S >admin health >go
Everything is OK if the word HEALTHY appears.
isql…
This post contains a step by step instruction on how to setup a warm standby replication.
The maintenance user is used by the replication server to apply transactions. Make sure that the…
