segunda-feira, 6 de agosto de 2012 07:42
I am reading on how to stop my distribution db from growing wildly, in doing this I find that there is a job I am supposed to have called: Distribution clean up: distribution job
Is there any reason why I wouldn't have this in SQL SRVR 2005 STD?
How do I go about adding it in?
Todas as Respostas
segunda-feira, 6 de agosto de 2012 12:28
I'm not sure why this job doesn't exist on your SQL Server (may be some one deleted this job by mistake). Follow these steps to recreated this job:
- Right-click Replication folder and choose Properties.
- Click on browse button and then choose values as follow:
- Click OK.
This will create the distribution clean job again on the server.
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
segunda-feira, 6 de agosto de 2012 12:38Moderador
It should be there - if you are running the express edition it will not be there.
If not just schedule a job that runs the following command:
EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72
Run it every 10 minutes.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Marcado como Resposta Shulei ChenModerator segunda-feira, 13 de agosto de 2012 08:48
terça-feira, 7 de agosto de 2012 05:56Thank you both, I will run the cleanup script first then add the job once its done and let you know!
quarta-feira, 8 de agosto de 2012 06:59I ran this and it cleaned up plenty! The distribution DB shrank significantly!