How to recover from transaction replication failure?
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.