March 3, 2008 at 1:44 am
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
March 3, 2008 at 3:54 pm
May the link below help.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2939682&SiteID=1
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply