Technical Articles, training, Database Consulting, Blogging

Replication Agents

Replication uses a number of standalone programs, called agents, to carry out the tasks associated with tracking changes and distributing data. By default, replication agents run as jobs scheduled under SQL Server Agent, and SQL Server Agent must be running for the jobs to run. Replication agents can also be run from the command line and by applications that use Replication Management Objects (RMO). Replication agents can be administered from SQL Server Replication Monitor and SQL Server Management Studio.

Snapshot Agent The Snapshot Agent is typically used with all types of replication. It prepares schema and initial data files of published tables and other objects, stores the snapshot files, and records information about synchronization in the distribution database. The Snapshot Agent runs at the Distributor.

Translator

Subscribe to this blog

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,029 other followers

Search @ SQLDBPOOL

Search for:

About Authors

Jugal Shah is the author & founder of this site. He has 14 plus years of experience as Cloud Solution Architect, Database Administrator and Developer in the Microsoft SQL Server, MySQL, PostgreSQL, MariaDB, Redshift and Aurora.

Email jugal.shah@sqldbpool.com

Server Server MVP (2010, 2011, 2012 and 2013)

Dhvani Shah is the author of this site. She has around 8 plus years of experience with the SQL Server and AWS cloud services. She has excellent skills in SQL Server database administration and development. She is also expert in RDS SQL Server, SSIS, SSRS and SSAS.

Blog Readers

1,842,266 Readers

Disclaimer

This is a personal blog. The opinions expressed here represent my own thoughts and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL/MySQL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have written my personal experience on this blog. Please don't direct implement or execute any query on production before have detailed study.