Log file of Database increases in every replication

[Abdul Rahman Hamidy]

Dear All, I have created replication in a single Database more than 20 times, since three years. now i have seen some thing amazing, In every replication the size of log file increases double the size of original file. as If the first log file is 1 GB then the new one is 2 GB I used to shrink this too, but i could not get any success, why its like this? what should i use in order to decrease this log. Note: I am using SQL 2005

Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan

[Lost User]

Abdul Rahman Hamidy wrote:

I used to shrink this too, but i could not get any success, why its like this?

It's there for your own security[^], I guess that the Recovery Model for the database is set to "Full". (Right click database, properties, options) There's an article here[^] that might help in shrinking it :)

I are Troll :)

[Abdul Rahman Hamidy]

thx, i think link can help me alot

Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan