Author : Sebastian Meine
Publisher : Red Gate Books
ISBN 13 : 9781906434991
Total Pages : 376 pages
Book Rating : 4.99/5 ( download)
Book Synopsis Fundamentals of SQL Server 2012 Replication by : Sebastian Meine
Download or read book Fundamentals of SQL Server 2012 Replication written by Sebastian Meine and published by Red Gate Books. This book was released on 2013-08 with total page 376 pages. Available in PDF, EPUB and Kindle. Book excerpt: It is a common requirement to make data that lives on one server available on another. Cross-server queries may be quicker by providing a local copy of the data; data may be made available to resource intensive reporting queries without affecting the OLTP load, maybe even with an intentional delay in synchronization, so that reports run against complete days only; or a complete database may be replicated to a secondary 'standby' server for high availability. In each case, SQL Server Replication is an option. This book provides the hands-on introduction needed to get started and explores all of the technology's most important strengths and weaknesses. It will help the reader decide whether replication meets requirements and which type of replication will be appropriate. It also offers guidance on when to avoid replication in favor of features such as simple log shipping, or the "Always On" feature set. This practical guide illustrates all major concepts with exercises. --