The information in this article applies to:
BUG #: 17811 (SQLBUG_65) SYMPTOMSThe cleanup task does not remove the entries in the MSjobs and MSjob_commands tables when all the publications are "scheduled table refresh" type publications. This may eventually fill up the distribution database. The cleanup task does remove the entries from the MSsubscriber_jobs table, as well as the bulk copy program (bcp) data files (.tmp files) in the replication working directory. CAUSE
The cleanup task calls the sp_replcleanup stored procedure, which removes
the information in MSsubscriber_jobs and MSsubscriber_status based on the
retention value. It removes records in the MSjobs and MSjob_commands tables
based on non-zero transaction ID. For scheduled table refresh type
publications, the transaction ID is always zero; therefore, the SELECT
statement to get the max(job_id) with xactid_page/row <> 0 returns NULL. WORKAROUNDTo work around this problem, drop and re-create sp_replcleanup with the following change in the section that deals with MSjobs entries:
STATUSMicrosoft has confirmed this to be a problem in SQL Server version 6.5. Additional query words: repl partial removal comparison
Keywords : SSrvRep SSrvTran_SQL kbbug6.50 |
Last Reviewed: April 19, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |