October 14, 2013 at 8:34 pm
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy