Primary keys are not replicated

  • Hi,

    I have a problem with replication. In our production environment we use two servers, one for production (which is a distributor and publisher) and one for backup (which is a subscriber). Both machines is running Windows 2003 and SQL Server 2000 with SP4. The replication is Transactional Replication using Push subscription.

    Our customers require that it is possible to shift server roles, i.e. production server becomes backup server and backup server becomes production server. Here comes the problem. When setting up replication (using guides in Enterprise Manager, not scripts) no primary keys are replicated.

    Does anyone know why primary keys are not replicated? and how I can replicate them?

    Best,

    J

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

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