Shulou(Shulou.com)05/31 Report--

This article will explain in detail about SQL SERVER 2012 database automatic backup method is what, the article content quality is high, so Xiaobian share for everyone to make a reference, I hope you read this article after the relevant knowledge has a certain understanding.

In order to prevent data loss, here are some ways to automatically backup SQL SERVER2012 data:

Open SQL Server 2012, as shown in the figure:

Server type: database engine;

Server name: 127.0.0.1(local), remote connection can also be selected;

Authentication: Contains Windows authentication and SQL Server authentication, select Windows authentication here;

2. As shown in the figure, select Manage--> Maintenance Plan--> Maintenance Plan Wizard:

3. On the SQL SERVER Maintenance Plan Wizard interface, click Next:

IV. Fill in the name and description as shown in the figure, click [Change]:

5. In the New Job Plan interface, select the frequency of database backup, as shown in the figure, and then confirm:

Plan type: repeated execution;

Frequency of implementation: weekly (daily, monthly);

Frequency per day: time of choice;

Duration: the default start time is the current time, and the end time can be left blank;

VI. As shown in the figure, the attributes of the current plan are displayed:

7. Select Backup Database (Complete) here, and then Next:

Eight, if there are multiple databases backed up at the same time, here you can choose the execution order, here default to one:

9. Select the database to be backed up (multiple choices are allowed):

X. Select the directory for database backup:

XI. Select the directory corresponding to the report file:

XII. In the Finish Wizard interface, you can see the details of setting backup:

13. At this point, the automatic database backup setting is complete!

Note: SQL SERVER must be started to perform automatic database backup.

About SQL SERVER 2012 database automatic backup method is what to share here, I hope the above content can have some help for everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.