Dsitribution database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dsitribution database

Hi<br /><br />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<br /><br />Any Ideas<br /><br /><br />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
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