My transaction replication works such that, to curb data growth, every day articles in publishers are purged but this purging of data is not replicated on to the subscriber. So at any point of time my publisher only has current day's data and my subscriber has archived data. How can I recover from a transaction replication failure? My publisher doesn't have all the data so I can't reinitialize my subscription.
How to recover from transaction replication failure
transactional-replication
Related Question
- SQL Server Replication – Initialize with Snapshot Using Filtered Rows
- Sql-server – Transactional Replication issues
- Sql-server – Transactional replication using articles filters and delete operations
- Sql-server – Transactional replication with updates on the subscriber
- Sql-server – Sql Server replication: Initial snapshot for publication is not yet available
Best Answer
1)Take a backup of your existing subscriber
2)Restore backup to another location
3)Reinitialize subscription
4)Load data from backup restore into reinitialized database
Going forward I would consider archiving data in another way as to not run into this problem again.