Post reply

Restore existing database without replication

  • June 10, 2008 at 5:49 am

    #192181

    Hi All,

    I currently have a database with two transactional replicated tables.

    For testing purposes, I want to restore a new copy of the DB to the same server with a different DB name.

    When I did this, the two replicated tables are still showing as replicated in the new copy of the DB. This is stopping me from making my required changes to these tables.

    How can I alter these tables so they are not replicated?

    I checked the replication articles and there is no reference to the new database only the existing version.

    Thanks in advance for any help.

    Paul

  • June 10, 2008 at 10:05 am

    #826782

    Paul,

    Just execute sp_removedbreplication 'newdatabasename' on this newly restored database.

    Let me know if this helps.

    Manu

  • June 10, 2008 at 11:13 am

    #826831

    MANU,

    Thanks that's fixed it.

    Paul.

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

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