SQL Server implements master-slave replication

Test environment: Host: Database SQL SERVER08 r2 system Windows Server R2 IP192.168.1.202

Cong: Database SQL Server12 system Windows IP192.168.1.100

Implementation steps: 1, first on the master-slave machine to add user sqladmin, Password * * * *, and set up under the Administeator (host for example)

2. Turn off the master and the firewall

3, set the startup type of SQL Server service and Proxy service to Automatic, log in for this account, browse to add the account you just added, enter the password, apply, and then restart the service,

4, open SQL Server Management Studio in the host and connect, register the cluster machine, while registering the host in the cluster machine, the server name is the computer name, after the test succeeds, save.

5. Add the login name in the login name of the master-slave and the database security, search for sqladmin, select SQL Server Authentication, OK.

6, add a user to the security in the database that you want to publish, and this user has the schema and database role memberships selected by db_owner OK.

7, the master-slave test data connection is available.

8. In the D disk new folder Sqlcopy, to hold the database snapshot, set up the share, and record the share path, set the read and write permissions to everyone.

9. Right-click Local publication under the database replication node of the host, create a new publication (if it has been published, click Copy, select Disable Publishing and distribution),

SQL Server implements master-slave replication