O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

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

Administering SQL Server Replication processes

Replication is the oldest data distribution technique within RDBMS and has been supported by SQL Server since version 6.5. Replication's main purpose is to copy data from one server to another, which is used as a marginal high availability feature for certain types of applications.

Replication agents are the key handlers that carry out all the tasks associated with replication, which includes creating a snapshot of schema and data, detecting updates, detecting conflict updates, and propagating changes between servers. All the replication agents are run under SQL Server agent job steps and these executables can be called directly from a batch script, or command-line operation. Replication provides a ...

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