Replication error when initializing

  • Hello, When I am initializing replication I get the following error: Cannot roll back sp_addpublication. No transaction or savepoint of that name was found. 25000.

    Has anybody seen this before? is this because a previous install was not uninstalled all the way?

  • Hi,

    Got any more detail!

    Have you dropped and re-created replication recently?

    What type of replication is it?

    Have you added any articles to the publication recently?

    What is your process in applying the replication ?

    Cheers...Graeme

  • Yes, Replication was dropped and now it is being recreated. It is on two servers. It is transactional replication. No articles have been added to publication recently but we did have a problem with the DTS not being allowed on one server. That has been corrected and now we receive that rollback error. Replication is being created by enterprise manager.

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

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