You didnt show how to set immediate sync\allow anonymous to zero: EXEC sp_changepublication @publication = 'Forest', @property = N'allow_anonymous', @value = 'false' GO EXEC sp_changepublication @publication = 'Forest', @property = N'immediate_sync', @value = 'false' GO
@michelleurbano0809
5 ай бұрын
Hello, am I right to alter the properties first on the affected publication before proceeding to add the articles right?
@ajaykumar-wc8gi
4 ай бұрын
Where is the the script which you shown in video to validate articles?
@KeshariDharmendra
3 ай бұрын
you can follow here www.dharmendrakeshari.com/add-new-articles-existing-transactional-replication-without-initializing-old-articles/
@theuserwanted
6 жыл бұрын
what is the reason it generate snapshot only for one table which is not in the subscriber? can you explain? to summarize I include the article first then generate snapshot? or there is/are some other step? thanks in advance.
@shovon100
6 жыл бұрын
you have to keep following properties disabled. otherwise old article will be regenerated on subscriber --Run on your publication database EXEC sp_changepublication @publication = 'test', --Enter your publication_name @property = 'allow_anonymous' , @value = 'false' GO EXEC sp_changepublication @publication = 'Test', --Enter your publication name @property = 'immediate_sync' , @value = 'false' GO -- then generate snapshot --then enable it back --Run on your publication database EXEC sp_changepublication @publication = 'test', --Enter your publication_name @property = 'allow_anonymous' , @value = 'true' GO EXEC sp_changepublication @publication = 'Test', --Enter your publication name @property = 'immediate_sync' , @value = 'true' GO
Пікірлер: 6