June 20, 2007 at 2:41 pm
Does anybody have experiences in shrinking distribution database? Currently I have a very big distribution data file, 60GB and I have been trying to shrink it down but it does not shrink down even though the shrinking execution did not give any error. The distribution data file just does not shrink down.
Please advise if you have some idea.
Thanks!
June 20, 2007 at 11:02 pm
Did you check what is the size it using if your data file is fully occupied then shrinking will not give you space.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 22, 2007 at 5:08 am
is your distribution agent cleanup task running? As sugesh says file will not shrink it it is full.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply