June 17, 2010 at 9:04 am
Hi
I am setting up replication between two versions of SQL Server in different domains.
Publisher : SQL 2005
Subscriber : SQL 2008
I have configured Distributor and Publication thru GUI
and configured subscriber thru T-SQL commands.
like below :
use [ReportDB]
exec sp_addsubscription
@publication = N'Publicationfor Report DB',
@subscriber = N'ABC01Server',
@destination_db = N'reportDB',
@subscription_type = N'push',
@sync_type = N'automatic',
@article = N'all',
@update_mode = N'read only',
@subscriber_type = 0
exec sp_addpushsubscription_agent
@publication = N'Publicationfor Report DB',
@subscriber = N'ABC01Server',
@subscriber_db = N'reportDB',
@job_login = null,
@job_password = null,
@subscriber_security_mode = 0,
@subscriber_login = N'Power',
---original val--@subscriber_password = null,
@subscriber_password = 'XXX',
@frequency_type = 4, @frequency_interval =
1,
@frequency_relative_interval = 1,
@frequency_recurrence_factor = 1,
@frequency_subday = 4,
@frequency_subday_interval = 15,
@active_start_time_of_day = 0,
@active_end_time_of_day = 235959,
@active_start_date = 20091123,
@active_end_date = 99991231,
@enabled_for_syncmgr = N'False',
@dts_package_location = N'Distributor'
GO
when I open replication monitor to view synchronization details i get message as
"The concurrent snapshot for publication 'Atlas' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for the publication"
so i checked the details of subscription in replication monitor...I see that Publisher to Distributor History is working fine...but in Distributor to Subscription History tab i see above message.
Can anybody tell me what to do ? This is very urgent
I appreciate quick responses.
November 8, 2016 at 1:35 pm
I'm hvaving the same issue. Does anyone know how to resolve or point me in the right direction?
November 9, 2016 at 3:16 am
Could u check logreader and Snapshot? Any of these is failing or giving some error?
BartL
Replication Blog
November 9, 2016 at 5:34 am
Snargables (11/8/2016)
I'm hvaving the same issue. Does anyone know how to resolve or point me in the right direction?
Snargables, suggest you start a new thread on this, not many are likely to watch this old thread.
😎
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply