Post reply

data is not replicating betwwwn two servers

  • October 21, 2010 at 5:08 am

    #230772

    Hi

    we implemented replication between 2 servers.But from one week onwards master data is not replicating to another server.

    All agents are running fine.From Repl monitor also we didn't find any error.When gone thru view synchronisatiuon status it is also running fine.

    i am not able find exact root cause .can any one suggest me is there any root cause for this issue.

  • October 21, 2010 at 9:06 am

    #1240387

    So this replication was working fine till last week? What kind of replication is this? Also try inserting a trace and see what is the value.

    -Roy

  • October 22, 2010 at 2:10 am

    #1240752

    Hi

    Thanks for replay...

    We are using Transactional publication with updatable subscriptions replication...

    As i mentioned above Application team found that past two weeks data is not replicating from server 1 to server 2.But after some time data is replicating automatically without taking any action.It is very starnge to me.

    I am not finding any error logs associated to replication from past two weeks onwards.Daily i will monitor replication.Thare also i didn't find any cahnge.All agents are also running fine.

    But one thing i observed....That is

    Here we accessing one server with two users.One domain and another is local.

    In one user application is running.If i am accessing server with this user in replication monitor server 2 publisher is not able to connect with distributor.

    If i login through another user there is no issue.

    This situation i am finding once data starts replicating...

    And please suggest me is there any other way to monitor replication daily.

    Kindly help me to solve this issue..

  • October 22, 2010 at 7:49 am

    #1240922

    In your replication set up of Publisher and distributor, do you have the Option "Sync with Backup" set?

    -Roy

  • October 25, 2010 at 12:22 am

    #1241424

    I am sorry ,,,

    where exactly i have to find this option "Sync with Backup"

  • October 25, 2010 at 2:25 pm

    #1241907

    Run the query

    SELECT DATABASEPROPERTYEX('Your Database Name', 'IsSyncWithBackup');

    If it returns 0, then it is not set.

    -Roy

  • October 19, 2011 at 12:37 pm

    #1396882

    What is the use of 'IsSyncWithBackup' property in database level?

    Is that really needed for Replication?

  • October 19, 2011 at 2:15 pm

    #1396952

    It specifies how you are synching the data to the subscriber.

    -Roy

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

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