The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P84: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Chapter 9 MCTS SQL Server 2008 Exam 432 Managing Replication Exam objectives in this chapter Replication Scenarios Replication Types Replication Configuration Conflict Resolution DDL Replication Security Considerations Replication Performance Monitoring Exam objectives review 0 Summary of Exam Objectives 0 Exam Objectives Fast Track 0 Exam Objectives Frequently Asked Questions 0 Self Test 0 Self Test Quick Answer Key 397 398 Chapter 9 Managing Replication Introduction Replication technology has been with SQL Server for several versions now. With each new version of SQL Server Replication you will see improvements the same applies to SQL Server 2008 as well. Replication is copying and distributing data between databases and then synchronizing them to maintain consistency and integrity. Head of the Class. Why Replication and Which Replication Type Because there are several methods for disaster recovery in SQL Server most of the time users are confused about which method to use when. Most of the users are more aware of replication than the other types . clustering mirroring and log shipping available to them so they will decide to use replication without knowing its features and limitations. However replication has several configurations to do compared with other disaster recovery methods. More importantly there are three main types of replication and users may not know which type of replication will be better suited for their problem. Replication is one of four methods available for high availability of your SQL Server Clustering Mirroring Log shipping Replication Replication has the advantage over the other technologies because it has the ability to filter rows or columns in a given table. Unlike mirroring and log shipping replication has the ability to provide readability in the primary and secondary databases. Managing Replication Chapter 9 399 You can implement replication for the following scenarios Improving Performance By implementing replication data is .
