Post reply

Replication Error Messages

  • July 12, 2010 at 11:38 am

    #235098

    I'm seeing the errors below in my sql log. It seems to be complaining about replication, but I'm not replicating anything. I have no "local publications" and no "local subscriptions". I did experiment with replication a while back, but I thought by getting rid of my publications/subscriptions replication would stop. Apparently not. How do I shut down replication?

    Here's the log errors:

    Date,Source,Severity,Message

    07/12/2010 10:15:00,spid51,Unknown,Replication-@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could not clean up the distribution transaction tables.

    07/12/2010 10:05:00,spid58,Unknown,Replication-@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could not clean up the distribution transaction tables.

    07/12/2010 09:55:00,spid69,Unknown,Replication-@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could not clean up the distribution transaction tables.

    07/12/2010 09:45:01,spid62,Unknown,Replication-@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0<c/>1<c/> or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could not clean up the distribution transaction tables.

    07/12/2010 09:40:54,spid23s,Unknown,Starting up database 'CSReplication'.

    .

  • July 13, 2010 at 2:05 pm

    #1192330

    Try running sp_removedbreplication. This should remove all left overs that you have.

    -Roy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply