Making single table snapshot using sql server 2005 enterprise

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

georgeg - 27 Aug 2008 16:33 GMT

I have created a publisher and snapshot some of the tables, which are
published to a subscriber.
Now I would like to snapshot a single table for this publisher. I checked
the table and start the snapshot agent, but it starts to snapshot all the
tables taht were snapshot before. Is ther some way to do this without doing a
snapshot of all the other tables?

Thanks

Signature

George Gopie

Reply to this Message

georgeg - 28 Aug 2008 21:40 GMT

Does anyone knows if ther is bug in Sql server 2005 Enterprise edition 64bit
for this issue? I was able to do this in sql server 2000 enterorise edition
withot any problems.

Thanks,

Signature

George Gopie

> I have created a publisher and snapshot some of the tables, which are
> published to a subscriber.
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Paul Ibison - 03 Oct 2008 15:54 GMT

George,

this is expected behaviour if you have a merge or snapshot publication. If
you have a transactional publication, a snapshot of all articles will always
be generated if the immediate_sync publication property is set to true.
Typically, the immediate_sync publication property is set to true if you
allowed anonymous subscriptions while creating the publication through the
CreatePublication wizard. To prevent the complete snapshot, run the script
below:

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

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

HTH,
Paul Ibison (www.replicationanswers.com)

Reply to this Message