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.