SQL Server2005 Master-slave Replication implementation

Transferred from: http://blog.csdn.net/gaojier1000/article/details/5805814

First, the preparatory work:
1. Establish a shared directory at the publisher as the repository for publishing snapshot files. For example: In the D packing directory under the folder named Pub;

2. Set up SQL agent (both Publisher and subscriber settings)

Steps:

--Open service (Control Panel ---management tool ---Service)-- right click on SQL Server AGENT---properties ---login ---Select "This account "- Enter or select the user password entered in the "password" of the WINDOWS user created in the first step;

3. Set SQL SERVER authentication To resolve permissions issues when connecting (publish, Subscribers are set) steps:

Object Explorer ----Right -click the SQL instance -----Properties ----Security ----Server Authentication ------SelectSQL Server and WINDOWS, and then click OK

4. Open The SQL Server 2005 Network protocol TCP/IP and pipe naming protocol and restart the Network service.

5. 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 ).

6. Publisher and Subscribers register with each other

Steps: View ----Click to register the server----right-clicking the Database engine ----New Server Registration -----Fill in the remote server name to be registered ------Authentication Select SQL server Authentication "-----User name (sa) password ------Create a group (or do not build)-----complete;

7. For IP only , cannot use the computer name, register the server alias for it.

Second, start:

Publisher configuration (Configure publications and subscriptions at the publisher)
1. Select a 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 step 1 )------Select the publication database-------Select the publication type-------Select the merge publication type -------Select the object to publish ------set the Snapshot Agent -------Fill out the publication name.

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.

Description: Using replication technology, users can publish a copy of the client's data to multiple servers, so that different server users can share this data within the scope of permission 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!

SQL Server2005 Master-slave Replication implementation