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.
Hi Sufian,
I need to take the snapshot of only & only the newly added articles, is this script useful in such a scenario????
Rojit,
Doing so only generates the snapshot of the new artical added to publication.
Regards
sufian