locked
Moving Distributed database from system database in Distribution server to another database RRS feed

  • Question

  • I have configured tracer tokens  on my distributed database which is in system database on by distributor instance.

    i want to move the distributed database to another instance database.

    is it possible ?

    how can we do that ?

    Friday, September 6, 2019 9:38 AM

Answers

  • You would need to drop all subscriptions, and publications, disable the publisher as a distributor, configure a remote distributor on the remote machine/instance, configure the publisher to use that remote distributor and then recreate your publications and subscriptions. 
    Friday, September 6, 2019 3:12 PM
    Answerer
  • Hi Sads_02,

    Please refer to SQL Server Transactional Replication Moving Distribution Database – step-by-step guide to get more information.

    Hope it could help you.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 9, 2019 7:51 AM
  • Hi,

    If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.

    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, September 11, 2019 9:39 AM

All replies

  • You would need to drop all subscriptions, and publications, disable the publisher as a distributor, configure a remote distributor on the remote machine/instance, configure the publisher to use that remote distributor and then recreate your publications and subscriptions. 
    Friday, September 6, 2019 3:12 PM
    Answerer
  • Hi Sads_02,

    Please refer to SQL Server Transactional Replication Moving Distribution Database – step-by-step guide to get more information.

    Hope it could help you.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 9, 2019 7:51 AM
  • Hi,

    If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.

    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, September 11, 2019 9:39 AM