Chapter 15 -- Using SQL Server Replication

3 4

Chapter 15

About This Chapter

This chapter prepares you to use SQL Server replication. You will learn about the types of replication that are available and physical replication topologies used to implement them. You will learn about the planning issues involved in setting up replication to perform efficiently and securely. You will learn to use SQL Server Enterprise Manager to implement replication, create publications, and configure Subscribers. Finally, you will learn to monitor replication and configure properties of Distributors and replication agents.

Before You Begin

To complete this chapter, you must have

• A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1, "Hardware Requirements," in the Lesson 1 section of Chapter 2.
• Microsoft Windows 2000 Server running on your computer on an NTFS partition.
• A computer with a NetBIOS name of SelfPacedCPU configured as a domain controller in the SelfPacedSQL.MSFT domain.
• Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2) .