Generate Snapshot for New Articles added to Publication

There is always this question how to generate snapshot for the articles which are newly added to the Publication.

Run the below command on the Publisher Server

EXEC sp_changepublication
@publication = ‘PublicationName’,
@property = N’allow_anonymous’,
@value = ‘false’
GO
EXEC sp_changepublication
@publication = ‘PublicationName’,
@property = N’immediate_sync’,
@value = ‘false’
GO

Now add new article to existing publication for which above command was executed and generate the snapshot.Snapshot for the newly addedartical will get generated. To check the same , check the snapshot Folder.

0 thoughts on “Generate Snapshot for New Articles added to Publication

  1. Hi Sufian,

    I need to take the snapshot of only & only the newly added articles, is this script useful in such a scenario????

Leave a Reply

Your email address will not be published. Required fields are marked *