Replication Sql Server 2008 R2

  • I installed Sql Server 2008 R2 Express and Advanced edition.

    But there is no Publication Folder in Replication.

    And there is No permission to create a new publisher.

    pls help me.

    Thanks...

  • Do you mean SQL Server Express Edition with Advanced Services? If so, that instance can only be used as a subscriber. Therefore, you cannot set up replicatioon or create a publication.

    Jared
    CE - Microsoft

  • yes. So pls let me know what is the correct version of sql server 2008 r2 has complete replication facility

  • Standard and higher will provide you with most replication. For Oracle or Peer to Peer, you must have Enterprise ed.

    Jared
    CE - Microsoft

  • Thanks Jared 🙂

  • I hope this link helps you to find correct version to use Replication.

    http://msdn.microsoft.com/en-us/library/cc645993.aspx#Replication

  • Are there any limitations on creating subscribers under one publication. (All are separate servers)

    I create two but when creates another "stating Agent" is running continuously and finally give an error.

  • I would start a new thread for this issue. Please include what type of replication you are using and how it is configured.

    Jared
    CE - Microsoft

  • Its a Merge replication. There is a central Server act as a publisher and another 6 severs need to set as Subscribers

Viewing 9 posts - 1 through 8 (of 8 total)

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