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.
Once finished with this book, you will be able to: - Differentiate the technologies and components that comprise replication, and explain how they work. - Set up transaction and merge replication environments. - Configure multi-server replication to follow the least-privilege security best practices. - Monitor and troubleshoot a replication environment.