SQL Server Performance Forum – Threads Archive

Dsitribution database

Hi I have implemented Transactional Replication on a 500 mb database. It all seems to work except the Distribution db grows untrollably and I have to turn off replication or it would fill up the disk Any Ideas PAt[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]

Check thishttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replplan_1l4e.asp out. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Hilary I was not very clear in my question Should I edit the cleanup task in the jobs section where the max retention size is appended after the MSdistribution_cleanup sp is specified ? or should I change it directly in the SP Also is 1 hour a good figure for the max retention size ? Cheers Pat

]]>