August 5, 2014 at 7:11 am
Hi,
In my local environment , i was setup transnational replication then i have added new article by using below script
EXEC sp_changepublication @publication = 'demo', @property =
N'allow_anonymous', @value='TRUE'
Go
EXEC sp_changepublication @publication = 'demo', @property =
N'immediate_sync', @value='TRUE'
EXEC sp_addarticle @publication = 'demo', @article ='employee',
@source_owner = 'dbo',
@source_object = 'employee',
@destination_owner = 'dbo', @force_invalidate_snapshot=1
EXEC sp_addsubscription @publication = 'demo',
@subscription_type = N'push',
@article = 'employee',
@subscriber ='A4-0036', @destination_db = 'SupSubscriber',
@reserved='Internal'
But article not added and showing this error message
The initial snapshot for article 'employee' is not yet available.
What is the issue, what can i do to add new article ? What did I mistake?
August 5, 2014 at 11:13 pm
PRR.DB (8/5/2014)
Hi,In my local environment , i was setup transnational replication then i have added new article by using below script
EXEC sp_changepublication @publication = 'demo', @property =
N'allow_anonymous', @value='TRUE'
Go
EXEC sp_changepublication @publication = 'demo', @property =
N'immediate_sync', @value='TRUE'
EXEC sp_addarticle @publication = 'demo', @article ='employee',
@source_owner = 'dbo',
@source_object = 'employee',
@destination_owner = 'dbo', @force_invalidate_snapshot=1
EXEC sp_addsubscription @publication = 'demo',
@subscription_type = N'push',
@article = 'employee',
@subscriber ='A4-0036', @destination_db = 'SupSubscriber',
@reserved='Internal'
But article not added and showing this error message
The initial snapshot for article 'employee' is not yet available.
What is the issue, what can i do to add new article ? What did I mistake?
As the error message says, the initial snapshot is not available, yet.
Have you tried starting the snapshot agent ?
August 5, 2014 at 11:34 pm
Hi all,
I ran below two lines code , then it is working fine.
EXEC sp_refreshsubscriptions N'<Publication Name>'
EXEC sp_startpublication_snapshot N'<Publication Name>'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply