The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P87: 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. | 412 Chapter 9 Managing Replication a centralized employee master database and for each location relevant employee data will be replicated. To do this you can use functions like HOST_NAME or SUSER_NAME . Dynamic filters are possible only with Merge Replication. Figure Adding Filters 10. The next screen sets schedules for the snapshot it is better if you can schedule the snapshot during off-peak hours of the database. 11. Next is the security setting which will be discussed in detail later. 12. Finally you have to assign a name for the publication. Configuration of Subscriber s After the configuration of Publisher the next task is to configure Subscriber to access data in the publications of Publisher. There can be one or more Subscribers to one Publisher. Exercise will help you to create a Subscriber. Managing Replication Chapter 9 413 EXERCISE Configuring Subscriber 1. Launch Open SQL Server Management Studio from Program Filesl SQL Server 2008. 2. Supply the correct authentication for you to login to the SQL Server in which you are going to configure the subscriber. 3. Navigate to the Replication node in the SQL Server Management Studio. In the Replication node select Local Subscription and right-click the node and select New Subscription. from the Context menu. 4. In the new subscription wizard after the starting page you will see the image shown in Figure . In this you can select the Publisher from the drop-down menu and it will list the databases and their publications. You have the option of selecting one Publisher from the list. Figure Choosing Replication for Subscriber 5. Next you need to specify whether the subscription is Pull or Push. This simply defines when the agents should run. If it is a Push subscription all agents will be run at the distributor. This option makes it easier to administer the synchronization of subscriptions 414 Chapter 9 Managing Replication centrally. Pull subscription will run the agents at the subscriber and .
