Post reply

replication

  • September 12, 2013 at 3:09 am

    #297733

    i did not implement replication in my current environment , i have 4 publishers iwant to know how many distribution and log agents for this ?

  • September 12, 2013 at 3:27 am

    #1649622

    You can use single distributor for all the 4 publishers.

    Every published database (for transaction replication) will have a log reader agent.

  • September 12, 2013 at 3:31 am

    #1649626

    The easiest way is to launch replication monitor, connect to the distributor and then view each of the agent types in the "Agents" tab.

    MCITP SQL 2005, MCSA SQL 2012

  • September 12, 2013 at 8:17 am

    #1649743

    Quick way connect to distribution database and run below .

    USE distribution

    GO

    SELECT * FROM MSdistribution_agents

    SELECT * FROM dbo.MSlogreader_agents

    SELECT * FROM dbo.MSsnapshot_agents

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

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