Post reply

Data Loss during Replication in SQL Server 2008 R2

  • October 14, 2013 at 8:34 pm

    #299647

    Hi,

    We are replicating data from dbx of source server A (SQL Server 2008R2) to another destination server B (SQL Server 2008R2) on dby database.

    Replication monitor doesn't show any error but over the period of time we find that dby is out of sync to dbx. We replicate all tables from dbx to dby.

    Time to time we do reboot destination server B but not the source server A. I have following questions.

    1. Can someone tell me that if destination server is rebooted then do we lose any data generated during reboot time from source to destination?

    2. Is reboot is an issue for source or destination server when replication process is ON?

    Thanks

    Chandra

  • October 14, 2013 at 9:30 pm

    #1658393

    The answer to both of your question is NO. Replication is quite happy operating in an environment where the servers are rebooted without stopping replication. Replication will simply resume processing from wherever it got to last time.

    If you are losing data, then check whether there is an application that is updating the subscriber in a way that you are not expecting.

    Also, do you have any filters on you articles.

  • October 14, 2013 at 11:15 pm

    #1658397

    Hi,

    Thanks for your quick reply. We do NOT have filters on any of the tables.

    I will check other applications. Replication monitor doesn't show any error.

    Regards

    Chandra

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

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