SQL Server geo-database daily synchronization job action steps

Implement real-time synchronization of Server a database dbname and Server B database dbname database data. The prerequisite for this job is that the database synchronization table structure for two servers must be exactly the same.

1) Publishing Server side:

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Subscriber Server side:

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Note: If the Publisher cannot connect to the Subscriber, configure the Subscriber, refer to http://www.cnblogs.com/sunxi/p/3408074.html

SQL Server geo-database daily synchronization job action steps