Break the replication

  • I have configured the Transaction replication

    Here i want to know how to break the transactional replication and i want re create it

    can u please provide the procedure for it

  • Hi,

    On the publisher instance right click Replication -> Disable Publishing & Distribution. Then follow through the wizard to disable it. Then create it as you did before.

    Is this what you're looking for?

    Dird


    Dird

  • Hope this helps...!

    http://msdn.microsoft.com/en-us/library/ms147921.aspx

    use [$(PublisherDatabase)]

    --Drop all subscriptions

    exec sp_dropsubscription

    @publication = N'TestPubs',

    @article = N'all',

    --@subscriber = [$(SubscriberServer)]

    @subscriber = N'all',

    @destination_db = N'all'

    --Drop publication

    if exists (Select 1 From SysPublications where name = N'TestPubs')

    EXEC sp_droppublication @publication = N'TestPubs'

    EXEC sp_replicationdboption @dbname = [$(PublisherDatabase)], @optname = N'publish', @value = N'false'

    --Drop subscriber entry

    EXEC sp_dropsubscriber @subscriber = [$(SubscriberServer)]

    --Drop distributor

    EXEC sp_dropdistributor @no_checks = 1

    Cheers,
    - Win
    "Dont Judge a Book by its Cover"

  • Yes

    Thank you very much

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

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