O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

Summary

Replication is a powerful feature of SQL Server that can be used in many business situations. Companies can use replication for anything from roll-up reporting to relieving the main server from ad hoc queries and reporting. It is critical to let your company’s requirements drive the type of replication technique to use. Determining the replication option and configuration to use is difficult, but actually setting it up is reasonably easy. Microsoft has come a long way in this regard. Peer-to-peer replication seems to have the most promise of delivering multimaster symmetric replication in a production environment. Microsoft’s overall architectural approach and implementation is the model for the industry. With the addition of Change ...

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