Forum Replies Created

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

  • RE: Unable to reset replication state.

    >You are going to truncate production database log in order to drop distribution database????

    No- a development database log. =)

    FWIW- I have never actually needed to apply a transaction log backup...

  • RE: distribution applies same transaction bundle repeatedly

    Follow-up:

    If you should ever face this issue, for us it had a rather cryptic cause.

    If you use @del_cmd = "NONE" then replication will not create the delete service routines for...

  • RE: Unable to reset replication state.

    My case was coming from restoring a database backup of a replicated database onto a system that wasn't using replication- there were no subscribers to drop, no replication to disable.

  • RE: Unable to reset replication state.

    Can't say if it worked for them but it worked for me!

    -- first tell repl it can let go of what it has already saved

    exec sp_repldone

    @xactid = NULL

    ,@xact_segno = NULL

    ,@numtrans...

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