Erik Hansson
Old Hand
Points: 395
More actions
June 18, 2010 at 6:22 am
#220205
my distribution database file is huge now approx 30 GB and it's still growing I have checked that the Distribution clean up job succeeds but it allways remove 0 replicated transactions consisting of 0 statements.
Does anyone know what to do?
ERIK
nikhil0416
SSC Veteran
Points: 209
June 18, 2010 at 6:53 am
#1182093
Did you check for fragmentation?
June 21, 2010 at 2:54 am
#1182598
This link solved my problem
http://www.mssqltips.com/tip.asp?tip=1823
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply