February 19, 2010 at 2:14 am
Need the checks for root cause and how can I reduce this size...its urgent
February 19, 2010 at 6:55 am
The usual reasons why the distribution DB gets big are because of the following.
1. Your distribution clean up Agent is not running or throwing an error
2. There are very old replication commands that could not be run.
I would suggest you try to check the first common issue first.
-Roy
February 20, 2010 at 1:16 am
Thanks for the reply
February 20, 2010 at 1:19 am
Thanks Roy
My problem is like the log file of the Distribution DB was abnormally increased to 13 GB from 1.9 GB.
How can I find the cause ???
is this advisable to shrink the Distribution DB??
I am using SQL 2k5 RTM Version .....
February 20, 2010 at 1:48 am
May be all the transactions are not completely copied to subscribers from distribution database.
Check Clean up job running on distributor. Is this database in simple recovery model?
You should be able to shrink the database with truncate only option.
I would script out the replication, Drop and rebuild from script again.
EnjoY!
February 22, 2010 at 6:24 am
Before you truncate anything, first check what recovery model your Distribution DB is
-Roy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply