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 ««12

Will Transactional Replication Supports Simple recovery Model ? Expand / Collapse
Author
Message
Posted Monday, August 18, 2014 12:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, September 6, 2014 2:55 AM
Points: 1, Visits: 13
As far as Replication is Concerned , There is no effect Of Recovery Model of the database in Updating the logged transactions back to the subscribers through Distributor .
In Simple Recovery Model Check Point Only clears the committed transactions from Log file and writes the pages back to disk , But in case Of Replication - changes made to the Published articles in the publisher will maintain a mark like 'marked for replication ' in the Log file . These Marked log records will not be truncated through checkpoint , Only cleared after they are updated to Distributor/Subscribers through Log reader Agent .

Hence , we can observe the Log file growth if there is any disturbance at distributor End in executing the Log reader Agent job .But you should be careful in case Of BULK OPERATIONS as they are minimally logged to log file.
Post #1604276
Posted Monday, August 18, 2014 2:34 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 40,438, Visits: 36,895
chandumca54 (8/18/2014)
But you should be careful in case Of BULK OPERATIONS as they are minimally logged to log file.


Not when there's transactional replication.
p.s. 3 year old thread.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1604306
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse