Post reply

Replication Sql Server 2008 R2

  • March 26, 2012 at 10:54 am

    #253722

    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...

  • March 26, 2012 at 10:57 am

    #1464429

    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

  • March 26, 2012 at 11:03 am

    #1464432

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

  • March 26, 2012 at 11:06 am

    #1464436

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

    Jared
    CE - Microsoft

  • March 26, 2012 at 11:12 am

    #1464441

    Thanks Jared 🙂

  • March 26, 2012 at 2:22 pm

    #1464544

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

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

  • April 3, 2012 at 9:39 am

    #1468311

    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.

  • April 3, 2012 at 10:23 am

    #1468336

    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

  • April 3, 2012 at 11:44 am

    #1468391

    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