* *---ningoo (nanjing) All rights reserved 2004.12---* *
I just got to work this morning and found the error in the Sync Replication Log Agent: The process could not execute ' sp_replcmds ' in ' servername '.
After searching the internet, I found some relevant information:
A bug can cause this error to occur before SQL Server SP2. http://support.microsoft.com/kb/q308865/
But I have hit the SP3a, it should not be the reason.
Others say to the agent profiles inside the value of the QueryTimeout set a large point, tried invalid.
View SQL Server Error log and discover the following records
error:9002, Severity:17, State:6
The log file for database ' servername ' are full. Back up the transaction log for the "database to" some log space.
Halo, is not enough disk space caused. Look at the DB log, full 25G, the weekend grow too fast, the entire disk space used up, sp_replcmds to generate synchronization data, but the hard disk has no space, causing the error occurred.
Solution:
Shrink log, free up enough disk space
Backup LOG servername with NO_LOG
DBCC SHRINKDATABASE (' servername ', truncateonly ')