Lesson Summary in .NET

Making PDF-417 2d barcode in .NET Lesson Summary

From SSMS, DBAs and user members of the replmonitor database role can launch SSRM to monitor the replication process. You can use SSRM to create replication alerts that automatically respond to replication events. Replication adds a set of performance objects and counters to System Monitor that you can use to create a baseline to monitor replication agents.

The following questions are intended to reinforce key information presented in this lesson. The questions are also available on the companion CD if you prefer to review them in electronic form.

Answers to these questions and explanations of why each answer choice is right or wrong are located in the Answers section at the end of the book.

1. Which tool is the most appropriate to monitor replication A. SQL Server Management Studio (SSMS) B. SQL Server Replication Monitor (SSRM) C. SQL Server Configuration Manager (SSCM) D. SQL Server Error and Usage Reporting (SSEUR)

19

2. Which tool should a DBA use to create a baseline to monitor replication A. SQL Server Management Studio (SSMS) B. SQL Server Replication Monitor (SSRM) C. System Monitor D. Event Viewer

Summary

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. SQL Server 2005 offers three major replication types: snapshot, transactional, and merge. Snapshot replication copies the whole set of data every time, transactional replication uses the transaction log to replicate changes only, and merge replication uses triggers and additional tables to allow multiple distributed updates of the same data and then uses conflict resolvers to define conflict winners and losers if there are data conflicts. SQL Server uses replication agents to implement replication. Replication agents should run with the fewest possible rights and account privileges to follow the important security concept called the principle of least privilege. Merge replication requires you to configure conflict resolvers, which are specialized components (.NET or COM) that can implement business logic to resolve data conflicts when replication servers simultaneously modify the same data. SSRM is the new monitoring tool that lets administrators supervise corporatewide replication processes from a single administration point.

Do you know what these key terms mean You can check your answers by looking up the terms in the glossary at the end of the book.

conflict resolver merge replication peer-to-peer replication pull subscription push subscription replication agent snapshot replication transactional replication

In the following case scenarios, you will apply what you ve learned about how to configure, secure, and monitor replication in SQL Server 2005. You can find answers to these questions in the Answers section at the end of this book.

Fabrikam, Inc., a leading manufacturer of digital cameras, recently acquired a new Video Products division to expand its product line, increase revenue, and grow overall market share of the company. The new Video Products division operates at a remote site and should remain as independent as possible. The marketing department requires weekly reports from the division based on a sales summary view. 1. What type of replication would you use to copy the sales summary data from the Video Products division server to the marketing server 2. You want to use a pull subscription for the replication configuration. What additional consideration must you take when configuring the replication 3. You want a member of the Marketing department to be able to monitor the replication processes. How would you grant monitoring access without giving excessive rights to the marketing representative

You are working as the DBA for a large university with seven schools that offer graduate and undergraduate programs. The university s enrollment is growing rapidly, and funds have been approved for seven new servers running SQL Server 2005 one server for each school. The servers will support the enrollment application, developed by in-house developers. Even when communication within the university network is very good, IT has agreed that each site should remain as independent as possible, and the enrollment application should be available when communication fails. As a rule, students enroll in the school they attend, although sometimes this is not the case. 1. What type of replication would you use to distribute the enrollment database 2. Before implementing replication, what application considerations do the DBAs need to take into account 3. In case of a conflict a very rare case of a student enrolling in two schools at the same time what alternatives could you give to programmers