Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transactional Replication - Inner workings Expand / Collapse
Author
Message
Posted Wednesday, October 31, 2012 2:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 1:16 AM
Points: 51, Visits: 338
Hi all
Just wondering how the inner working of replication happens. eg. You have server A replication to Server B. (transactional replication). You have a pull replication setup on Server B with the Distribution db on Server A along with the publication

Scenario:
You have a job that imports data into server A at 5am (runs for 2 hours), another job at 6am (runs for 2 hours) and one more at 7am (runs for 2 hours). The data is being imported into SQL by these jobs and they getting transferred to Server B via replication. (Also please don't mention replication monitor, cause in my experience its not very accurate!!!). How does the data get committed to server A with multiple jobs running and how does the data transfer itself to server B. Is this done by means of a que on the distribution? how does the log reader identify which records to read first and which to transfer first on the publication? Are the transactions grouped into files? if it is, where are these files held and what order are they transferred?
I know alot of questions, but any positive feedback will be highly appreciated!

Thanks!!!
Post #1379198
Posted Thursday, November 1, 2012 5:33 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 20, 2014 8:32 PM
Points: 3,062, Visits: 2,672
How about having a look at the info published by Microsoft on how replication works. There is stacks of info available in Book Online, Technet and MSDN. Perhaps start with "How Transactional Replication Works" (http://msdn.microsoft.com/en-us/library/ms151706(v=sql.100).aspx)


Post #1380091
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse