sql server replication: Shrinking "Distribution" db log file in TR -- sql server replication

Shrinking "Distribution" db log file in TR

Suchi
9/10/2007 3:12:01 PM

sql server replication: Hi All,
Environment:SQL server2000 on Windows2003
We have few TRs set up on this server.The log size of distribution database
is around 4.5 GB. Shall i shrink it? If yes, please let me know the
precautions to be taken before shrinking it.
The recover model of Distribution db Simple and full backup is happening
every day.

Thanks in Advance

Re: Shrinking "Distribution" db log file in TR

Hilary Cotter
9/10/2007 10:18:31 PM

Yes, also make it full recovery model and dump it regularly, perhaps once an
hour. This should maintain its size. You should not have to shrink it on an
ongoing basis.

There are no precautions you should be taking.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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]