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 100gig it might indicate Distribution Cleanup processes is having a hard time deleting already delivered transactions.  In SQL Server 2017 you can customize the cleanup batch size via SQL Server Management Studio under the Distributor properties dialog, however, for…

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