Replication Failed

  • Bluesky-539179

    SSC-Addicted

    Points: 449

    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.

  • Snargables

    SSCrazy Eights

    Points: 8666

    I'm hvaving the same issue. Does anyone know how to resolve or point me in the right direction?

  • Bart Lewandowski

    Ten Centuries

    Points: 1079

    Could u check logreader and Snapshot? Any of these is failing or giving some error?

  • Eirikur Eiriksson

    SSC Guru

    Points: 182343

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply