Home > Generate Snapshot for New artical added to Publication > Generate Snapshot for New Articles added to Publication

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.

  1. Rojit
    April 12, 2010 at 3:00 pm

    Hi Sufian,

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

    • msufian
      April 14, 2010 at 2:36 pm

      Rojit,

      Doing so only generates the snapshot of the new artical added to publication.
      Regards
      sufian

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: