This section describes the steps to achieve replication. (Take a snapshot copy as an example)
Test Environment: Two SQL Server 2000 Services A and B, configure A to publish and distribute servers, b configured to subscribe to the server to be published for DB_TEST, the publication to be published is table TB_TEST
The following steps are completed on A
1. Create a shared directory, use the storage directory of the released snapshot file, the path is D: / RDATA, share the named RDATA
2. Set the boot user of the SQL Agent (SQLServerAgent)
Start - Program - Administrative Tool - Services - Right - Login - Select "This Account" - Enter "./administrator", or choose Other System Administrators - "Password" Enter The user's password
3. Set the SQL Server authentication mode to solve the permissions when connecting
Enterprise Manager - Right-Type SQL Instance - Property - Security - Authentication - Select SQL Server and Windows - Determine 4. Register each Mutual Manager on the Publisher and Subscriber - Right-click SQL Server Group - New SQL Server Registration ... - Next - In the available server, enter the remote server name you want to register - Add - Next - Connection, select the second "SQL Server authentication "- Next - Enter Username and Password - Next - Select SQL Server Group, you can also create a new group - Next - Finish the official start:
1. Configure the publishing server
a. Select the specified [Server] Node B. Select [Publish, Subscriber and Distribution] command c. The system pops up a dialog box point [Next] and then look at the prompt operation - Until "Specify Snapshot Folder" - Enter the directory created in the preparation work in the "Snapshot Folder": // A / RDATA One [Next] Direct operation. d. After the setting of the publishing server is completed, the system will add a copy monitor to the tree structure of the server and generate a distribution database (Distribution).
2. Create a release a. Select the specified server b. Select [Create and Manage Publish] commands from the [Copy] submenu of the [Tools] menu. The system will pop up a dialog box. Select Database DB_TEST, and then click [Create Publish] D. In the [Create Publish Wizard] prompt dialog box, click [Next] system will pop up a dialog box. The content on the dialog is three types of replication. Select the first snapshot release E. Click [Next] System requirements Specify that you can subscribe to the published database server type, select the database server f running "SQL Server 2000", click [Next], select the object you want to publish TB_TESTG. Then [Next] until the operation is complete. The database created after the publication is completed, it will become a shared database.
-------------------------------------------------- -------------------------
3. Design subscription subscription methods have two types: forced subscription and request subscription
Here is the step of enforcement:
Enterprise Manager - Replication - Publishing Content - Right-click Publications - Select to force new subscriptions, open Welcome to force book wizard, click [Next] - Select Server B, click [Next] - Enter db_test in the Subscribe Database Name, click [Next] - You can schedule your subscription, click [Next] - Left steps click [Next] until [complete ]
Here is the step of requesting subscription,
a. Select the specified subscription server BB. Select [Request Subscription] C from [Tool]] C. Click [Next] by prompted to click [Next] to check the operation of the SQL Server Agent service. The prerequisite for performing replication operations is that the SQL Server proxy service must have been started. d. Click [Finish] to complete the subscription operation.
How to detect if the configuration is successful: 1. Expand the copy of the publishing server - Publish content - Right click on the content - Properties - Hit - Status The Status is immediately run the agent, then the agent property hits the schedule to schedule Set to every day, every minute, between 0:00:00 and 23:59:59.
2, check out if you have multiple UNC directories in the D: / RData directory
3. Open B subscribe to the database, do you have more subscription table TB_TEST