Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Saturday, October 13, 2018 1:44 AM
After add more records on to Publisher site, not replicate to subscriber site. The table already on "Articles"
local Publisher->properties ->Re-Initialization all subscribers heading to configure snapshot agent which I don't need it. Is there any way to start sync? or alternative
Saturday, October 13, 2018 10:00 PM ✅Answered
Hi Philfactor
I do not need to start the snapshot agent job as DB is pretty large and take ages to compete . Was issue with Last LSN no not able to chat up from subscriber.
step I did:
1. Drop the subscriber.
2. backup DB from publisher, backup log from publisher
3. restore on Subscriber both DB and Log.
follow this scripts:
This is amazing note. Its works on me.
Many thanks
Saturday, October 13, 2018 7:48 AM
Try right-clicking the publication > choose 'View snapshot agent status' > If agent is not running, click the 'start' button.
Allow a few minutes for re-sync to copy data over to subscriber.
HTH,
Phil Streiff, MCDBA, MCITP, MCSA