replication merge failing

  • Hi i have a publisher which is 12.5 gigs large and i have a subscriber that is in our offshore office connected through a vpn tunnel. The subscriber database crashed owing to hardware failure and i had to rebuild the server and restart the sync process using merge subscription. The database has Audios as varmax binary in one of the tables.

    After i reinit the replication it ran for 36 hours and was 100 mb away from completion(i checked size of subs and publisher dbases) and finally gave me a generic error saying data base or merge agent doesn't have write permissions. So restarted it last night again and it in progress. When i click on the view sync status it shows BULKCOPIED data int MSMERGE_CONTENTS(174167) and it has been on that state for more than 12 hours already.

    what is the best way for me to get the subscriber going without any issues and run smoothly.

  • Did you ever resolve your issue?

    Joie Andrew
    "Since 1982"

Viewing 2 posts - 1 through 1 (of 1 total)

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