So I had to rebuild a server that was subscriber using pull replication. Currently I'm restoring the database on the subscriber form backup and it's a big one. I know from previous recovery test that this will take about 5 hours. Now I'm planning on applying DIFF and Log backups as needed when the Full backup restore is finished...yes I set it to NO RECOVERY. 😉 Now my transaction log (min) retention is 8 hours based on my distributor properties. The full backup is from about 19 hours ago.
Now my question is how do I add this subscriber on the publisher without it causing any data consistency errors. I'm assuming when I run my sp_addsubscription command with the initialize from backup (using the same backup) that it will attempt to run all the transactions since the backup but many of them will already have been applied. Unfortunately, I can't just restore the DB without applying the updated logs since the distributor will not have those logs older than 8 hours.
I'm wondering if I could use a different strategy here but I was afraid any other form of recovery would have taken much longer considering the size of the database in question.
SELECT quote FROM brain WHERE original = 1
0 rows returned