Replication

Transactional Replication and the Ballooning Log File

A drive on a mission-critical server is reaching capacity, and the new DBA is panicking. How do you approach a ballooning log file that won’t stop growing?

Replication between SQL Server versions

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.

Snapshot Agent

Replication

Replication

Replicating Data with Mobile Clients - SQL Server 2012

Replicating A Volume Of Large Data via Transactional Replication

During weekend maintenance, members of the support team executed an UPDATE statement against the database on the OLTP Server. This database was a part of Transactional Replication, and once the UPDATE statement was executed the Replication procedure came to a halt with an error message. Satnam Singh decided to work on this case and try to find an efficient solution to rebuild the procedure without significant downtime.

Replication: Distribution Agent Monitoring

Learn about the distribution agent and how to identify replication bottlenecks.