Sometimes you need to make data that lives on one server available on another server. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load. In these cases it can be useful to look at SQL Server replication.
Download your free copy of Fundamentals of SQL Server 2012 Replication by Sebastian Meine to get a hands-on introduction to SQL Server replication. By the end of the book, you will be able to make an informed decision about whether replication is the right feature to use, and which type of replication best fits your situation.
Then to keep an eye on the health of your transactional replications, pick up your free trial of SQL Monitor.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data