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: Friday, December 06, 2013 12:45 AM
Points: 51, Visits: 321
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 01, 2012 5:33 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:21 PM
Points: 2,842, Visits: 2,423
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