May 14, 2012 at 2:02 pm
hello
anyone help me please
i am working with a large database and i have replicated this through a slow vpn and i need to initialize a snapshot from a backup becouse sometimes it is necesary and if a reestart the snapshop is not possible to pass all the data from the slow vpn.
i know that with the instruction sp_addsubscription it can do it but i dont know how to used correctly, i've followed this url http://msdn.microsoft.com/en-us/library/ms147834.aspx, but there indicated to run the script in the publisher but dont nkow how to connect to the subscriber the script that i use is the following
exec sp_addsubscription
@publication = 'rplCTL_PRODUCTOS',
@subscriber = 'xxxxxxxxx',
@destination_db = 'bd1replica',
@subscription_type = 'Push',
@sync_type = 'initialize with backup',
@backupdevicetype='disk',
@backupdevicename='G:\Respaldos\Bases de datos\BD1Replica.bak',
@fileidhint=1
go
it rus correctly but when i go to see the status for the subscription is has the following error "The process could not connect to subscriber xxxxxxxxx" and the procces is stopped
someone can help me please
Greetings from Mexico
i am to serve you
thanks
May 19, 2012 at 10:45 am
Security isn't set up correctly. How is the distribution agent connecting to the subscriber? Check the accounts and permissions.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply