When will distribution log file size shrink? -- sql server replication

Chen
4/20/2006 11:57:02 AM

Hi,

I set up the transactional replication for our pre-product db server (EE2000
on Windows 2003 with 64 bit). The distribution database data file allocate
size is 947MB and used 113.69MB, but the transaction log file allocation size
is 2463.8MB and used 2421.5MB. The Log Reader and push agent status are No
replicated transactions are available.

My questions are: when the distribution log file size will auto shrinking to
small? From my understood, once the transactions pushed data to subscriber
site, the log file shouldn't like that big. What does contain in the log file?

Regards!

Chen
4/20/2006 1:29:02 PM

Hi Paul,

Actually, I am not doing backup since the space problem on this server, but
I thought the distribution database db option set with trunc. log on chkpt.
It should auto shrinking when check point occur. Am I right?

Regards!
chen

[quoted text, click to view]

Hilary Cotter
4/20/2006 4:54:06 PM

If your distribution database is in full recovery model a backup will allow
you to shrink it.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Paul Ibison
4/20/2006 9:15:03 PM

Chen - are you backing up the distribution database log?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul Ibison
4/20/2006 9:48:33 PM

Chen,
OK - are you trying to shrink the log then? What is the %useage of the log?
Are there some open transactions in there (dbcc opentran).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : When will distribution log file size shrink?