SQL SERVER 2008 database copy tutorial [graphic]

To back up data in a timely manner, you can use full backup + differential backup or log backup. This article introduces how to use the database replication technology to synchronize data:

PS: The article focuses on images. The pictures show the operation steps and configuration methods more intuitively!

1. First create a test database named FA_BU to publish data. Because it is a demo, there are two fields.

 

 

2. Release the database. Here I will release the local FA_BU database.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3. Local subscription. You can select another server.

 

 

 

 

In the next step, select the server to be released:

 

 

 

 

 

 

The create database dialog box is displayed when you select "create database" as follows:

 

 

 

 

Next, you need to set the access permission. Click the button next to it to go to the settings page:

 

 

 

 

 

 

Set Schedule as follows:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

4. Now let's test it. First query the data in the two databases and we can find that the data is empty.

 

 

INSERT a piece of data in the FA_BU database,

 

 

Query the data of the two databases again and find that the data has been synchronized, as shown in the following figure: