Hi All,
My distribution database has been growing very drastically in size. The size of the mdf file is 42 GB whereas the size of the ldf file is 23 GB. I have checked that the distribution clean up task job has been running successfully on the server.
We have been using SQL 2005 Standard Edition with Service Pack2.
I am aware that i cannot truncate the MSRepl_Commands table which is the huge one otherwise my replication chain will break up.
Also i have executed the below query against the distribution database:
select count(*) from msdistribution_status and it gave me the result a 1566, what i understand is 1566 transactions are yet to be distributed to the subscribers.
Any help would be appreciated.
With Thanks,
Satnam