Can publisher server connected to multiple distributor

Hi,
Anyone know how could I connect to 2 or more distributor for single publisher? I have an instance of sql server (publisher) with few db and I want it to connect to difference distributor. Currently I only saw one distributor exist and there is no option to create configure another one in EM.

sp_get_distributor only show one as  now.

installed distribution server        distribution db installed is distribution publisher has remote distribution publisher
--------- ------------------------------------------------ ------------------------- ------------------------- -----------------------
1         TSD001\SQL1               0                         0                         0


motioneyeAsked:
Who is Participating?
 
imran_fastCommented:
You can have only one distributor for a given server publications.

The question is why you want two seperate distributor for the same publisher.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.