July 19, 2009 at 11:33 am
Hi Friends,
Can we perform Replication with Simple Recover Model?
Normally we keep it in Full recover model, right???
Any thought would be helpful.
Thanks in advance.
July 19, 2009 at 12:43 pm
The short answer is yes, those types of replication that use the transaction log will not truncate the log until transactions marked for replication are transferred to the distribution database.
It would be best practice though not to for all the reasons of recoverability you normally require on a production database.
---------------------------------------------------------------------
July 20, 2009 at 11:57 am
George, can you please give me more clarity on this!
upto my knowledge, in SIMPLE recovery model, the T-log gets truncated whenever CKPT occurs or whenever 70% of the T-log is full.
How would this allow replication in Simple model?????????
Can you give more clarity on this??
July 20, 2009 at 12:14 pm
Only the INactive part of the log is truncated, the active part, i.e transactions that are not commited yet or in the case of replication not passed to the distribution database, will not be truncated (and therefore removed from the log).
In simple mode the truncation will only happen up to the oldest active transaction in the log file, this is why a long running open transaction will prevent the log file truncating and a log file can still grow in simple mode.
---------------------------------------------------------------------
July 20, 2009 at 1:56 pm
mahesh.vsp (7/20/2009)
upto my knowledge, in SIMPLE recovery model, the T-log gets truncated whenever CKPT occurs or whenever 70% of the T-log is full.How would this allow replication in Simple model?????????
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply