Đang chuẩn bị liên kết để tải về tài liệu:
Microsoft Press microsoft sql server 2005 PHẦN 9

Phương pháp đơn giản nhất để cấu hình nhân rộng thông qua SSMS. Tuy nhiên, bạn cũng có thể sử dụng báo cáo Transact-SQL hoặc RMOs SQL Server để cấu hình sao chép. Các bước chung để cấu hình sao chép như sau: 1. Thiết lập một nhà phân phối cho Nhà xuất bản sử dụng. 2. Tạo ra một công bố để nhân rộng bao gồm các bài viết mà bạn muốn sao chép. | 706 Chapter 19 Managing Replication Lesson 2 Setting Up Replication The most straightforward method to configure replication is via SSMS. But you can also use Transact-SQL statements or SQL Server RMOs to configure replication. The general steps for configuring replication are as follows 1. Set up a Distributor for the Publisher to use. 2. Create a publication to replicate that includes the articles you want to copy. 3. Configure the Subscriber and a subscription. In this lesson you see how to use SSMS to perform these steps to configure a replication topology. You also see how to generate the equivalent Transact-SQL configuration scripts. After this lesson you will be able to Create the distribution database. Enable a database for replication. Create a publication. Subscribe to a publication. Estimated lesson time 40 minutes How to Set Up the Distributor The first step in setting up replication is configuring the Distributor. You can assign each Publisher to only one Distributor instance but multiple Publishers can share a Distributor. As noted earlier you can configure the Distributor server to act as the distributor of its own data local Distributor which is the default or as a distributor of data for remote servers remote Distributor . BEST PRACTICES Remote Distributor You might decide to use a remote Distributor if you want to offload the Distributor processing from the Publisher computer to another computer or if you want to configure a centralized Distributor for multiple Publishers. Note that the server you choose as the Distributor should have adequate disk space and processor power to support replication and the other activities that need to run on that server. Lesson 2 Setting Up Replication 707 Here is how to configure the Distributor as a local Distributor 1. Open SSMS. 2. Connect to the database engine instance you want to configure as Publisher and Distributor. 3. Right-click the Replication folder and choose Configure Distribution. 4. On the .