• Hi,
    I think this is impossible, if you try to add new article to your subscription, and you play with these 2 parameters:

    EXEC sp_changepublication
    @publication = 'your_publication_name',
    @property = 'allow_anonymous',
    @value = 'false'
    GO

    EXEC sp_changepublication
    @publication = 'your_publication_name',
    @property = 'immediate_sync',
    @value = 'false'
    GO

    you only create a snapshot for the new article. In your case, if the table ist x TB big, you create a snapshot with x TB.

    Kind regards,
    Andreas