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

Will Transactional Replication Supports Simple recovery Model ? Expand / Collapse
Author
Message
Posted Sunday, March 27, 2011 10:20 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 7:52 AM
Points: 49, Visits: 147
Hi
I got a doubt in Transactional replication .
Wil it supports for simple recovery model databases?
My doubt is transactions are truncated automatically in simple recovery when check point occurs,then how sync will happen in transactional replication.
Please help me .
Post #1084684
Posted Monday, March 28, 2011 1:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:32 AM
Points: 1,327, Visits: 4,504
Yes, you can use the Simple recovery model... the transaction log is only truncated after a checkpoint AND all transaction marked for replication have been processed.


Post #1084737
Posted Monday, March 28, 2011 1:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 7:52 AM
Points: 49, Visits: 147
Thank You very much..
Am i right in this..
"transactions are replicated before check point occurs in transactional replication "
Post #1084744
Posted Monday, March 28, 2011 2:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, June 16, 2014 7:32 AM
Points: 1,327, Visits: 4,504
gvram6 (3/28/2011)
"transactions are replicated before check point occurs in transactional replication "

I don't really understand that statememt... where did you see it?

The checkpoint process has nothing to do with replication. It writes changed pages from memory to disc.

The only tie in with replication is with truncation of the transaction log. In simple recovery, this normally happens after a checkpoint, but if there are replicated transactions in the log, truncation of the log has to wait until they have been processed as well.



Post #1084762
Posted Monday, March 28, 2011 2:40 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: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
Not necessarily. They could be sent before, they could be sent after, it really doesn't matter.

http://sqlinthewild.co.za/index.php/2008/12/05/a-new-sql-myth/



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 #1084763
Posted Monday, March 28, 2011 2:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 7:52 AM
Points: 49, Visits: 147
Got Cleared ...now..
Thanks alot..
Post #1084778
Posted Saturday, June 15, 2013 1:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 3, 2013 12:59 PM
Points: 7, Visits: 14
is there transaction log in simple recovery model
Post #1463831
Posted Saturday, June 15, 2013 2:10 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: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
Of course.


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 #1463833
Posted Saturday, June 15, 2013 9:50 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 7:48 PM
Points: 8,545, Visits: 9,034
manikanta1207 (6/15/2013)
is there transaction log in simple recovery model

Yes. There has to be a transaction log, because if uncommitted changes have been written to disc and the system breaks it has to be able to undo those changes when it comes up again - and roll-back of uncommitted transactions is carried out based on the uncommitted changes recorded in the transaction log. Also, when the system breaks there may be a transaction that has been committed and some of whose updates are recorded only in RAM store and in the transaction log (because a checkpoint hasn't yet occurred since that transaction was committed) - and recovery when the system comes back up has to ensure that those updates are applied to the database records, so it has to retrieve those updates from the transaction log.


Tom
Post #1463862
Posted Sunday, June 16, 2013 11:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 3, 2013 12:59 PM
Points: 7, Visits: 14
thankyou
Post #1463994
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse