Issues with Adding a new subscriber to an existing transactional replication setup

  • I am trying to add a new subscriber to an existing transactional replication with pull subscription.

    Steps followed:

    At the publisher:

    1. Changed the value for allow_initialize_from_backup to true using execute sp_changepublication

    2. Create the backup of publication database

    3. Restored the backup on the subscriber daatbase

    4. At the publisher on the publication database, exeucted the following script to add the subscription

    use [subscription_db]

    exec sp_addsubscription @publication = N'Trans', @article = 'all', @subscriber = N'subscriber-server', @destination_db = N'testdb', @sync_type = N'initialize with backup', @backupdevicetype = N'Disk', @backupdevicename = N'C:\testdb.bak',

    @subscription_type = N'pull', @update_mode = N'read only'

    GO

    5. At the subscriber server on the subsribing database, executed the following script to add pull subscription

    use [testdb]

    exec sp_addpullsubscription @publisher = N'publisher-server', @publication = N'Trans', @publisher_db = N'testdb',

    @independent_agent = N'True', @subscription_type = N'pull', @description = N'', @update_mode = N'read only', @immediate_sync = 0

    go

    exec sp_addpullsubscription_agent @publisher = N'publisher-server', @publisher_db = N'testdb', @publication = N'Trans', @distributor = N'distributo-server', @distributor_security_mode = 0,

    @distributor_login = N'xxx', @distributor_password = 'xxxx', @enabled_for_syncmgr = N'False', @frequency_type = 64, @frequency_interval = 0, @frequency_relative_interval = 0, @frequency_recurrence_factor = 0,

    @frequency_subday = 0, @frequency_subday_interval = 0, @active_start_time_of_day = 0, @active_end_time_of_day = 235959, @active_start_date = 20130606, @active_end_date = 99991231, @alt_snapshot_folder = N'',

    @working_directory = N'', @use_ftp = N'False', @job_login = null, @job_password = null, @publication_type = 0

    GO

    Everything looks fine till now, and when i synchronize the subscription, i am running into an errors like

    Cannot update identity column col1

    Could not find stored procedure 'sp_MSins_dboTABLE'

    Can you guys please help

Viewing 0 posts

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