Post reply

replication

  • June 30, 2003 at 8:39 am

    #81089

    Hi,

    I need some help with replication. I am new to DBA position in my company.We have replication betwwen 4 servers.we are getting the data into server 4 from servers 1,2 and 3.

    we have the table Xxxx in all the 4 servers. Now we are going to add two columns to the table. basiacally i dont know which replication they are using already and which server is a publisher and which is subscriber,how should i know all the details.If i wanted to add the two columns what should i do with the existing replication? can i modify it with some procedure or should i recreate the new replication. please help me in this issue.

    Thanks..

  • July 1, 2003 at 6:29 am

    #463755

    Looks like you have merge replication set up. Your server 4 is the subscriber and your server 1, 2, 3 are the publishers. Run this at each of the server to find the db that have replication set up in them -- sp_helpreplicationdboption.

    Check sp_repladdcolumn and sp_repldropcolumn for adding or dropping columns from your publications.

    Hope this helps.


    Joseph

Viewing 2 posts - 1 through 1 (of 1 total)

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