O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

Replication Overview and Terminology

As stated earlier, SQL Server 2000 has added many new enhancements to data replication. This chapter focuses on introducing you to SQL Server replication terminology and the different types of replication. Additionally it shows you how to perform standard administrative tasks such as creating a distribution database. The next two chapters will get into more detail as they walk you through transactional, merge, and snapshot replication. To become familiar with replication terminology, consider the replication scenario shown in Figure 27.1. With transactional replication, the publication is modified at the publisher's site and the changes are replicated to the subscribers of the publication.

Figure 27.1. Overview ...

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