I have a transaction replication and the subscription was synced from snapshot years ago. Now I have a new table that needs to be added to the replication. Problem is the table is close to a TB and I do not want to generate a snapshot for that table instead just want the new data to be synced, kinda like when you sync from backup. Its inserts only to the table and I can sync the old data manually later.
How do I make replication to start transferring the data without generating the snapshot.
add article to publication with sp_addarticle and after this run sp_addsubscription with @sync_type = 'replication support only"
check @sync_type parameter.
https://msdn.microsoft.com/en-us/library/ms181702.aspx