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


Will Transactional Replication Supports Simple recovery Model ?


Will Transactional Replication Supports Simple recovery Model ?

Author
Message
gvram6
gvram6
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 256
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 .
Ian Scarlett
Ian Scarlett
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2203 Visits: 6864
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.



gvram6
gvram6
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 256
Thank You very much..
Am i right in this..
"transactions are replicated before check point occurs in transactional replication "
Ian Scarlett
Ian Scarlett
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2203 Visits: 6864
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.



GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86877 Visits: 45263
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, MVP, M.Sc (Comp Sci)
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


gvram6
gvram6
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 256
Got Cleared ...now..
Thanks alot..
manikanta1207
manikanta1207
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 14
is there transaction log in simple recovery model
GilaMonster
GilaMonster
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86877 Visits: 45263
Of course.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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


TomThomson
TomThomson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14250 Visits: 12197
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

manikanta1207
manikanta1207
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 14
thankyou
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