Post reply

Break the replication

  • April 19, 2013 at 11:33 pm

    #274186

    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

  • April 20, 2013 at 11:35 am

    #1608488

    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

  • April 20, 2013 at 10:23 pm

    #1608527

    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"

  • April 21, 2013 at 11:10 pm

    #1608583

    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