SQL SERVER 2005 Synchronous Replication Technology (RPM)

SQL Server 2005 Synchronous replication technology The following replication steps (take snapshot replication as an example) run the platform SQL Server 20,051, prepare to work: 1. Establish a WINDOWS user, set as administrator rights, and set a password as a valid access user to publish the snapshot files. 2. It is normal for the publisher and subscriber to communicate under SQL Server (that is, you can exchange visits). Open 1433 port and set the exception 3 in the firewall. Establish a shared directory at the publisher as the repository for publishing snapshot files. For example: Under the D packing directory, the folder is named Sqlcopy 4. Set SQL Agent (both Publisher and Subscriber settings) This article was posted on www.xker.com (Small new technology Network) Open Service (Control Panel---Administrative tools---services)---Right-click the SQL Server Agent---Properties---Log on---Select this account ---Enter or select the Windows user that you created in the first step---password, enter the user password 5. Set SQL Server Authentication, resolve permissions issues when connecting (publish, Subscribers are set) Step: Object Explorer----Right-click the SQL Instance-----Properties----Security----Server Authentication------Select SQL Server and Windows, and then click OK 6. Open the SQL Server 2005 Network protocol TCP/IP and pipe naming protocol and restart the Network service. 7. In SQL Server, create the system user login name in step 1 as the owner of the publication database (set to Dbo_owner and public). 8. Establish the database and table with the system superuser sa login to SQL Server. 9. The Publisher and Subscriber registration steps are as follows: View----Click to register the server----right-clicking the database engine----New Server registration-----Fill in the remote server name to register------authentication Select SQL Server Authentication-----user name (SA) The password------to create the group (or not)-----complete. 10. For IP only, cannot use the computer name, register server alias two, start: Publisher configuration (Configure publishing and subscriptions at the Publisher) 1. Select Replication Node 2. Right-click Local publishing----Next---------the System Pop-up dialog box to see the prompt----until the Specify Snapshot folder----Enter the directory that you created in the snapshot folder (point to the shared folder that you built in step 3)------ Select a publication database-------Choose a Publication type-------Select a subscriptionRead server type-------Select the object to publish------set the Snapshot Agent-------fill out the publication name. This article was published in www.xker.com (Small technology Network) 3. Right-click Local subscription--------Select Publisher-------Select a subscription method (if you subscribe to the server, select push subscription instead Select a pull subscription)-------Fill the Subscriber--------Select the agent plan (which is generally selected for continuous operation)---------the rest of the selection defaults. At this point, SQL SERVER 2005 synchronous replication is complete. Using replication technology, users can publish data from a single client to multiple servers, allowing different server users to share this data within the permitted scope of permissions. Replication technology ensures that data is automatically synchronized and updated at different locations to ensure data consistency, eliminating the need for programmatic client and server-side data synchronization!  Greatly improve the work efficiency!