Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    4

    Post Unanswered: Database Replication problem

    Hi,
    I have two branch offices, in two different countries (Country A and Country B). In there I have several MS SQL Database servers.
    Country A: Server A1, Server A2
    Country B: Server B1, Server B2
    All servers are connected via internet through local VPN.
    I want to configure database replication between Server A1 and Server B1. But it does not working correctly. I want to configure Merge replication. I have followed all the necessary process for replication and I did not found any error or warning. The problem is after configuration all the tables of Server A1 are not created in server B1. Only System Tables are generated.
    I have set the replication snap shot agent after 10 minutes in a day.
    Remember that Replication for server A1 & A2 or Server B1 & B2 works nicely for same configuration.
    Can anyone help me to overcome this problem?

    [NB: I am using Microsoft SQL Server 2008]

    Thanks in advance
    Rashed
    Last edited by rasadulalam; 04-25-12 at 02:36.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Has the distribution job run, yet? The snapshot job only creates the scripts for the subscribed tables, it does not apply those scripts.

  3. #3
    Join Date
    Jul 2010
    Posts
    4
    Quote Originally Posted by MCrowley View Post
    Has the distribution job run, yet? The snapshot job only creates the scripts for the subscribed tables, it does not apply those scripts.
    Yes It is running

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    What errors, or other messages are listed in the Replication Monitor?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •