O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4: Transactional Replication

  • Question: I have two subscriptions configured and one of them is not working, what should I check?

    Answer:We should check if the distribution agent is running, and check if there are any errors reported. If required try to reinitialize subscription and use replication monitor to watch what is happening.

  • Question: I get the following error: Insert failed because of conflict with identity range check constraint. How do I solve it?

    Answer: We should be careful when we use Identity with replication. Ideally we should manually assign the range at both the ends — Publisher and Subscriber — if we are using updatable subscription. Also, it is to be noted that Identity keys and triggers should be marked as Not for Replication. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required