Distribution database is too big;

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Distribution database is too big;

16 posts, Page 2 of 2

««1 2

Distribution database is too big;

Rate Topic

Display Mode

Topic Options

Author

Message

Roy Ernest

Posted Friday, November 27, 2009 5:00 AM

Hall of Fame

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:24 AM
Points: 3,280, Visits: 6,619

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

thatguyivan

Posted Monday, January 11, 2010 4:47 PM

Forum 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

dm_tapas

Posted Tuesday, September 25, 2012 7:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:23 AM
Points: 1,004, Visits: 260

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

Suresh B.

Posted Tuesday, September 25, 2012 11:16 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:59 AM
Points: 1,075, Visits: 5,114

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

tapaskumardm

Posted Tuesday, September 25, 2012 12:38 PM

SSC 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

Suresh B.

Posted Wednesday, September 26, 2012 6:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:59 AM
Points: 1,075, Visits: 5,114

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 »

16 posts, Page 2 of 2

««1 2

Permissions