June 7, 2013 at 2:15 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy