FIX: Subscriptions are incorrectly marked inactive although the subscriptions are synchronized in the retention period (823649)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
SQL Server 8.0:221046 SYMPTOMSAlthough the
subscriptions are synchronized in the maximum transaction retention period of
the distribution database in Microsoft SQL Server 2000, the Distribution Agent cleanup job that runs on the distributor may incorrectly mark the
subscriptions as inactive. As a result, the Distribution Agent may fail, and
you may receive the following error message in the Error
message pane of the Distribution Agent Error Details
dialog box: The subscription(s) have been marked inactive
and must be reinitialized. NoSync subscriptions will need to be dropped and
recreated. RESOLUTIONTo resolve this problem, obtain the latest service pack for
SQL Server 2000.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211
INF: How to obtain the latest SQL Server 2000 service pack
STATUSMicrosoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
This bug was corrected in SQL Server 2000 Service Pack 3.
REFERENCESFor more information about subscription deactivation, see
the "Subscription Deactivation and Expiration" topic in SQL Server Books
Online.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
834670
BUG: Subscriptions are incorrectly marked as inactive even if the subscriptions are synchronized within the maximum transaction retention period in SQL Server 7.0
| Modification Type: | Minor | Last Reviewed: | 5/26/2006 |
|---|
| Keywords: | kbReplication kberrmsg kbStoredProc kbfix kbbug KB823649 kbAudDeveloper |
|---|
|