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

What Is Snapshot Replication?

Snapshot replication takes a picture of the data (that is, copies all the data in the table as defined by the article) at a certain point in time and replicates the snapshot of data to subscribers. Snapshot replication can be thought of as a “table refresh” because all the information for the article is exported and loaded into the subscriber's table. With snapshot replication, no transactional information is kept or required. SQL Server 2000 gives you the flexibility to determine how the subscriber's tables are refreshed. Tables can be dropped and re-created, tables can be truncated (that is, all the rows are deleted) and the data refreshed, or the data can be added to an existing table without dropping the table ...

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