Post reply

Re-initialization of transcational replication fail

  • February 13, 2015 at 2:27 am

    #398016

    Hi All,

    I have configured three transactional replication one from DC - Data center & DB for database

    DC1-DB1 to DC2-DB1 -- 1

    DC2-DB1 to DC2-DB2 --2

    DC2-DB2 to -DC2-DB3 --3

    Before synching the data on DC2 databases I wanted to truncate / drop the objects on 1 and 2 setup as these are already participating in replication. Setup 1 and 2 are publisher as well as subscriber. I am not able to reinitialize these tables on these setup.

    Could you please share any other approach to synch the data. I cannot use SSIS.

    "More Green More Oxygen !! Plant a tree today"

  • February 13, 2015 at 7:27 am

    #1777508

    Your question isn't clear enough.

    Could you be more specific as to the problem you're having?

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • February 15, 2015 at 11:01 pm

    #1777750

    In my replication R1 and R2 and R3 , I am not able to reinitialize as R1 and R2 act as both publisher and subscriber.

    How do I handle re initialization in a transactional replication, when a subscriber act as a publisher for the same articles.

    "More Green More Oxygen !! Plant a tree today"

  • February 24, 2015 at 12:39 pm

    #1779712

    Minaz Amin (2/15/2015)

    In my replication R1 and R2 and R3 , I am not able to reinitialize as R1 and R2 act as both publisher and subscriber.

    How do I handle re initialization in a transactional replication, when a subscriber act as a publisher for the same articles.

    What is the error message?

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

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