SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Transactional replication issues


Transactional replication issues

Author
Message
CRAZY99
CRAZY99
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 373
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
- Win
- Win
SSC Veteran
SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)

Group: General Forum Members
Points: 252 Visits: 631
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"
chandan_jha18
chandan_jha18
SSC Eights!
SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)

Group: General Forum Members
Points: 933 Visits: 2134
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search