The reason for the previous release server to restart the Agent to copy data to the subscription server is as follows:. For the "Step 2" in this sentence, please refer to the beginning of this article.
The job for clearing expired commands REPL-clear distribution runs every 10 minutes. At this time, no new data will be copied to the Business Database on the subscription server. Restart the SQL server agent. Log reading will restart the job and repeat the preceding steps.
New data will be copied to the Service database on the subscription server. Change the data records of this stored procedure to data records each time.
After a day's deletion operation, the data volume changes to again. In this case, it takes only a few seconds for the REPL-clear distribution job to complete. For details, refer:. This article is an English version of an article which is originally in the Chinese language on aliyun. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof.
If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact alibabacloud. A staff member will contact you within 5 working days.
Once verified, infringing content will be removed immediately. 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. Create a free Team What is Teams?
Learn more. Asked 9 years, 3 months ago. Active 6 years, 10 months ago. Viewed 7k times. Improve this question. Add a comment. Active Oldest Votes. Improve this answer. Thanks for the reply. I have run into that with actual jobs also and have changed many to sa, but this is running continuous so that is not a job.
Have looked through everything in publication properties and don't see anything. It actually is a job. DLL libraries which within those libraries simply run command line applications. In this case you are running the log reader, so it's running logread.
The job will be on the distributor, not on the publisher. It is being used in a number of places. I am assuming that it is an alias for the domain account that is causing the error. How and where is this being set? Show 3 more comments. I found that if you use article filters, you must use a unique filter name.
Once I changed the filter name to be unique across all articles, it fixed this issue. In our case the service account that the SQL instance was running on got locked. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 11 years, 6 months ago. Active 2 years, 5 months ago. Viewed 59k times.
Improve this question. Wayne Conrad Add a comment. Active Oldest Votes. Improve this answer. Mattias Nordqvist Mattias Nordqvist 6 6 silver badges 14 14 bronze badges. This answer saved my sanity! It is easy to do. Saved my day. Thanks a ton mate, saved my hours of efforts.
0コメント