Retrieving lost source data
If you lose source you can possibly retrieve it through a recovery point method or a full refresh.
About this task
If a source table is forward recovered to the point of failure, SQL Replication proceeds normally. After the table is recovered, the Capture program continues collecting data changes for the table.
However, the Capture and Apply programs do not detect a point-in-time recovery of a read-only target table. If you recover a source table, the Apply program might have replicated changes to the target tables that no longer exist at the source, leaving inconsistencies between your source tables and target tables if you cannot take the target tables back to the same logical point in time.
This scenario becomes even more complex when there are multiple levels of replication. You must either develop a mechanism that provides matching recovery points among the various levels or use a full refresh as your recovery method of choice.
Procedure
| Method | Description |
|---|---|
| Recovery point mechanism | Develop a mechanism that provides matching recovery points among the various levels of replication. |
| Full refresh | Use a full refresh as your recovery method of choice |