April 14, 2013 at 3:28 am
Hello There,
I am new to this forum,
Could anyone help me with this questions please.
I am working in retail industry and has some doubts relating to this topics.
Our company has 100 stores and the data has to be replicated to the main subscriber server from all the 100 publishers. We have set up a transnational replication with one distributor. In a region for some 15 stores we have network issues, the data was not replicated to the main server.
1.How can we replicate the data when the network is back to normal ?
2.If any of the remote server gets crashed, how do we restore the publication after the server gets normal (what is the procedure to follow) ?
- How do we apply changes to remote servers using Transactional Replication
· If there was an issue with a certain server, how do we stop and restart replication
· How do we apply changes to a replicated server
April 18, 2013 at 12:53 am
This could you help you to understand the setup and process.
http://msdn.microsoft.com/en-us/library/ms146922(v=sql.90).aspx
http://msdn.microsoft.com/en-us/library/ms151196.aspx
Some more information from external blog - http://sqlphilomath.wordpress.com/2011/08/07/how-to-configure-transactional-replication-with-updatable-subscriptions-step-by-step/
NOTE : http://msdn.microsoft.com/en-us/library/ms143550%28v=SQL.110%29.aspx
Cheers,
- Win
"Dont Judge a Book by its Cover"
April 22, 2013 at 5:06 am
When you talk of an issue with some server, I will say that when it comes up replication will assume automatically from where it left off.
Lets say that the publisher server is down, so it means no new data changes are going to occur and the distributor will have no work to do until it comes up and subscriber's data will be the same when the publisher had gone down. So just focus on getting the publisher up and replication will catch up on its own.
If distributor server is down then the publisher will keep a track of all 'to-be-replicated' commands in its log file and when distributor comes up, log reader agent will scan all the logs and send the information to the distributor and then only changes to subscriber will start. so again, just focus on getting the distributor server up.
If subscriber goes down, you will have all changes kept in distributor , waiting to be propagated. so again, focus on getting subscriber up,.
For higher network latencies, try using different agent profile for log reader and distributor agent with more time-out values, small commits etc.
Thanks
Chandan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply