The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P91: 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. | 432 Chapter 9 Managing Replication Conflict Resolution 0 In Merge Replication you can set Publisher to win when a conflict exists. Also you have the option of setting the priorities for subscribers. 0 Apart from default settings you can customize the conflict resolution for date time and values. 0 In Peer-to-Peer Replication conflict resolution is introduced with SQL Server 2008 and the highest number of peer originator id wins when there is a conflict. DDL Replication 0 DDL Replication is enabled by default. 0 DDL Replication will be failed at SQL Server 2000 when it is a subscriber for Merge Replication. Security Considerations 0 Recommended practice is to use a unique domain user account to connect to publishers and distributors rather than using a SQL Server Agent account. 0 A better option is to run the agent service account using the domain user account. Replication Performance 0 Always try to limit replication objects as much as possible. You can ignore the unnecessary database objects and columns. 0 Pull subscriber will reduce the load of the distributor when there are lots of subscribers. 0 Try to schedule creating snapshots during an off-peak time of the database load. Monitoring 0 Replication Monitor is a SQL Server in-built monitoring tool. 0 Performance Monitor perfmon also is used for replication monitoring. 0 You can create alerts so that operators can take proactive decisions. Managing Replication Chapter 9 433 Exam Objectives Frequently Asked Questions Q What is the difference between replication and clustering A Clustering is for entire database server and you can implement replication for database objects level and filter horizontally rows and vertically columns . In clustering cost is higher than the replication. Q What is the difference between replication and mirroring or log shipping A Mirroring or log shipping is for the entire database. You can implement replication for database objects level and filter horizontally rows and vertically .
