PHISSUG

For you guys who implement replication, how do you manage the replicated (target) database? Like file size growth on the target, transaction log getting filled, etc.

 

I use to change the Recovery Model to "Simple" of the target database then shrink the transaction log file group. After that it will reset the transaction log file to 1MB.

 

---

Jimmy Mcp, Mcdba

Thanks for the suggestion, bossing.  I was under the impression that replication, like log shipping, relies on the transaction log to commit the transactions related to the replcated data.  Changing the database recovery model to simple will truncate the logs and cause the replication to fail (which is what happened when I did just that).