Synchronous replication error: The process could not execute ' sp_replcmds ' on ' servername '

Source: Internet
Author: User
Tags server error log

* *---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 ')

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.