Post reply

Replication - Subscriber limit in SQL 2008?

  • March 14, 2011 at 12:18 pm

    #389041

    Is there a limit to the number of subscribers per publication in SQL 2008 Enterprise?

    I thought I saw something about 2005 have a limit of 25, but I was unable to find this information on SQL 2008.

    Thanks!

  • March 17, 2011 at 6:54 am

    #1299909

    Really...no one can answer this for me?

  • March 17, 2011 at 7:22 am

    #1299920

    sql 2005 express supports config as a subscriber only to both merge & transactional replication.

    sql 2005 workgroup supports config as a publisher to 25 subscribers for merge replication and publisher to only 5 subscribers for transactional replication.

    sql 2005 standard doesn't support oracle replication.

    sql 2005 standard and enterprise do not have a limit.

    For SQL 2008

    If an instance of Workgroup is used as a Publisher, it supports a maximum of 25 publications to all merge subscriptions. It supports an unlimited number of subscriptions to snapshot publications.

    this is from microsoft's site on the editions page.

    2005

    http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

    2008

    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    chris

  • March 17, 2011 at 7:29 am

    #1299930

    Thank you. For some reason I couldnt find that info. Google failed me.

  • March 8, 2012 at 8:32 am

    #1456572

    I have personally set up SQL server 2005 enterprise with 45 subscribers i hope this is the same for SQL server 2008 Enterprise

  • March 8, 2012 at 9:28 am

    #1456625

    You will hit an OS limit on the number distribution agents you'll be able to run. That depends partly on hardware. So if you're planning on having a large number of subscribers you will want to look at potentially using pull subscriptions.

Viewing 6 posts - 1 through 5 (of 5 total)

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