Analysis on the idea of Master-Slave replication based on SQL SERVER

This article mainly introduces SQL SERVER to achieve master-slave replication thinking analysis, the text is very detailed, has a certain reference value, interested friends must read!

Two SQL servers

2. install SQL Server

3. The server adds the sqldmin user and adds it to the Administrators group. Give sql sysadmin serveradmin privileges (some tutorials do not explain)

4. Add sqladmin to sql agent account and ensure sql agent service is enabled

5.! [] right-click properties to configure sql proxy services

6. Create shared folders to store sql backup files and grant sqldmin full control.

7. Right-click the database you want to synchronize to select properties

8. Turn on backup settings in transaction log shipping

9. The latter is basically operated according to the panel. I don't want to explain too much.

10. After completion, the server will display the following words

The above is "SQL SERVER to achieve master-slave replication thinking analysis" all the contents of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!