Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication is a hands-on introduction to SQL Server replication. It is often necessary for data that lives on one server to be made available on another server. You might want to speed up cross-server queries by providing a local copy of the data or make the data available to resource intensive reporting queries without affecting the OLTP load. You may wish to replicate a complete database to a secondary 'standby' server for high availability. In each case, SQL Server Replication is a viable option, and Fundamentals of SQL Server 2012 Replication provides the hands-on introduction you need to get started. <br /><br />Once finished with this book, you will be able to:<br />- Differentiate the technologies and components that comprise replication, and explain how they work.<br />- Set up transaction and merge replication environments.<br />- Configure multi-server replication to follow the least-privilege security best practices.<br />- Monitor and troubleshoot a replication environment.<br />