Mssql Replication (step 1)

I. Cấu hình phân phối đầu tiên, bạn phải kết nối với SQL Server phân phối: 1. Mở SQL Server 2005 Management Studio. 2. Nếu bạn không phải đã được kết nối với trường hợp của SQL Server mà sẽ phục vụ như là nhà phân phối, hãy nhấp vào Object Explorer và chọn dụ. Click vào đây để xem ảnh nhỏ. Hình 1. Kết nối với các nhà phân phối Sau khi bạn đã kết nối với Ví dụ, bắt đầu xuất bản New Wizard....
Nội dung trích xuất từ tài liệu:
Mssql Replication (step 1)Step I. Configure DistributionFirst, you must connect to the SQL Server Distributor:1. Open SQL Server 2005 Management Studio.2. If you are not already connected to the instance of SQL Server that will serve asthe Distributor, click Object Explorer and select the instance. Click this bar to view the small image.Figure 1. Connecting to the DistributorAfter you have connected to the instance, start the New Publication Wizard.1. Expand the server node.2. Expand the Replication folder.3. Right-click the Local Publications folder and then click Configure Distribution Click this bar to view the small image.Figure 2. Starting the Configure Distribution Wizard4.The Configure Distribution Wizard introduction page is displayed.Click Next Click this bar to view the small image.Figure 3. the Configure Distribution Wizard page5.Verify that the instance that you are connected to is selected as the Distributor andclick Next. Click this bar to view the small image.Figure 4. Specifying the Distributor6.Specify Snapshot Folder This snapshot folder does not support pull subscriptionscreated at the Subscriber. It is not a network path or it is a drive letter mapped to anetwork path. To support both push and pull subscriptions, use a network path torefer to this folder. Click this bar to view the small image.Figure 5.Specify the Snapshot Folder7.Specify Distribution Database .Locate the distribution database and log files.ClickNext Click this bar to view the small image.Figure 6. specifying distribution database8.Specify Publisher.Enable servers to use this distributor when they becomepublisher.click Next Click this bar to view the small image.Figure 7. Specifying publisher and distribution database9. On the Wizard Actions page, you specify the distribution will be created, andwhether the distribution configuration is saved in a script. We recommend that youselect the check box for scripting so that you will have a copy of the distributionconfiguration for future reference. click Next. Click this bar to view the small image.Figure 8. Scripting and creating the distribution10. specify the distributor of script ,Click Next. Click this bar to view the small image.Figure 9. Specify the distributor script11. On the Complete the Wizard page, verify that all options are correct.Click Finish Click this bar to view the small image.Figure 10. Verifying wizard options12. The Distribution Wizard now saves the configuration information that you haveentered and creates the distribution.Click Close after the steps are complete Click this bar to view the small image.Figure 11. Creating the distribution13. Specifying the connection propertiesRight-click the Replication folder and then click Distribution Properties Click this bar to view the small image.Figure 12. Specifying the connection properties Click this bar to view the small image.Figure 13. Saving the Distributor configuration