How to resolve when Distribution Database is growing huge (+25gig)

Yes, I know, huge database is kind of relative, but generally if you see Distribution database growing more the 25gig it means the Cleanup processes is having a hard time deleting replicated transactions.  I’ll cover the how and why on Cleanup processes later, but for now I wanted to post a technique we’ve used to…

3

Troubleshooting Distribution Agent message code 8144. Procedure or function sp_MSupd_Address has too many arguments specified.

I thought it would be helpful to post some Replication Distribution Agent troubleshooting steps to help you not only understand more about Replication components, but to also show how I approach Replication problems. Problem: SQL 2005 Distribution Agent was failing with following messages 2009-12-29 00:17:53.917 Agent message code 8144. Procedure or function sp_MSupd_dboAddress has too…

0

Troubleshooting Snapshot Agent hang

I recently got a customer call where the SQL 2008 Snapshot Agent appeared to hang when started from SSMS. As you can see, pop-up status window shows “Starting agent”.  So, looks like its running, but it stays this way forever. Replication Monitor also shows as “Running”. If I double-click the I can zoom in on…

2