Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Distribution database is too big; Expand / Collapse
Author
Message
Posted Friday, November 27, 2009 5:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:00 AM
Points: 2,361, Visits: 6,745
Next time it runs, it should clean up everything. But it will take time to run the clean up Job. I think you should try to run the clean up job manually. Just copy the command from the Job step and run it through SSMS. But that will not make the DB size small. But the latency will drop down to a manageable level.

-Roy
Post #825557
Posted Monday, January 11, 2010 4:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 11, 2010 4:45 PM
Points: 1, Visits: 0
Try this link, I believe it describes your problem.

http://www.mssqltips.com/tip.asp?tip=1823
Post #845771
Posted Tuesday, September 25, 2012 7:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 8:14 AM
Points: 1,024, Visits: 393
I have the same Issue. I did all the above steps,

but when I run the Job 'Agent history clean up : Distribution' .. the log file is growing rapidly.

What can be done to resolve the issue.

Thanks in advanced
Post #1364033
Posted Tuesday, September 25, 2012 11:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
What is the recovery model of your Distribution database?
It is supposed to be "Simple". If it is something else, change it to Simple.

Post #1364187
Posted Tuesday, September 25, 2012 12:38 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 4:48 AM
Points: 282, Visits: 116
Simple recovery model.

when the job 'Agent history clean up: distribution’ is executing the log file is growing rapidly.
so i disabled the job for now.
will it effect the replication ??
up to what extents.
Post #1364238
Posted Wednesday, September 26, 2012 6:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 2:53 AM
Points: 1,101, Visits: 5,290
Please run the following script to check why log entries are not removed:
select name, log_reuse_wait, log_reuse_wait_desc 
from sys.databases
where name = 'Distribution'

Also run:
dbcc opentran()

Post #1364601
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse