Microsoft SQL Server 2008 R2 Unleashed- P65:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 584 CHAPTER 19 Replication option lower-right side of this dialog . Make sure you see Success after each step of this configuration. FIGURE Configuring the distributor and enabling a publisher in progress. Now is probably a good time to locate that distributor setup and enabling publication script and drop it into your replication administrator folder that you keep in a safe place. Figure shows what this script looks like. Notice that the password is not displayed. The details of these scripts are described later in this chapter in the Scripting Replication section. When the distributor is configured and the distribution database is created a series of replication agents managed by SQL Server Agent are created with various duties as described earlier in this chapter. Figure shows the initial set of agents created on the distribution server as seen from the Job Activity Monitor under the SQL Server Agent . No agents exist yet that actually publish data or distribute data. Those agents are created later as you start publishing and subscribing. Creating a Publication When the distribution database has been created and publishing has been enabled on the server you can create and configure a publication. In SQL Server Management Studio you start by locating the Replication node under the publication server from which you want to publish data the DBARCH-LT2 SQL08DE01 named instance in this example . Figure shows the program item option when you right-click the Replication node under what will be the publication server. As you can see there are three options one to create a new publication one to create a new Oracle publication and one to create a new subscription. Download from Setting Up Replication 585 FIGURE The script generated for creating the distributor and enabling a publisher. FIGURE Initial replication agents on the distributor. 19 Download from 586 CHAPTER 19 Replication I L ai3D3SeS I 3 .
