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

Prerequisites for Snapshot Replication

In the previous section, we saw that the Snapshot Replication is the basic and simplest replication topology. We should be very aware and familiar with the way Snapshot Replication can be implemented and the way it works. There is another reason for the need to be familiar with Snapshot Replication — even if we plan to implement Transactional or Merge Replication, the initial replication that gets applied is the Snapshot Replication. Therefore, we should be careful when we decide to design and implement replication solutions in our environment. There are a few prerequisites and considerations to be taken care of before implementing Snapshot Replication.

  • Primary Key: Tables without a primary key cannot be ...

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