SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

SQL Server Replication SQL Server 2008 replication, like the versions of SQL Server before it, is based on a magazine publishing model. You must configure the publisher, distributor, and subscriber to complete a replication configuration.

Replication can be implemented using one of three core replication methods. The first is transactional replication and offers near real-time updates. The second is snapshot replication, and it has lower latency but only consumes network bandwidth periodically. The third is merge replication and is used when updates must be allowed at both the publisher and the subscriber.

Importing and Exporting Data Data can be imported and exported using several methods in SQL Server 2008. The Import/Export ...