Shulou(Shulou.com)06/01 Report--

In order to prevent data loss, here are the methods of automatic backup of SQL SERVER2012 data:

Open SQL SERVER 2012, as shown in the figure:

Server type: database engine

Server name: 127.0.0.1 (local), or you can choose a remote connection

Authentication: includes Windows authentication and SQL Server authentication, select Windows authentication here

2. As shown in the figure, select * * manage * *-> * * maintenance Plan * *-> * * maintenance Plan Wizard * *:

3. In the "SQL SERVER maintenance Plan Wizard" interface, click "next":

4. Fill in the name and description as shown in the figure, and click "change":

5. In the "New Job schedule" interface, select the frequency of database backups, as shown in the figure, and then determine:

Plan type: repeat execution

Frequency execution: weekly (daily, monthly)

Daily frequency: time of choice

Duration: the start time defaults to the current time, and the end time can be left empty.

6. As shown in the figure, show the properties of the current plan:

7. Select * * backup Database (complete) * * here, and then * * next * *:

8. If multiple databases are backed up at the same time, you can choose the execution order here. One is the default here:

9. Select the database to be backed up (you can choose more than one):

10. Select the directory for database backup:

11. Select the directory corresponding to the report file:

12. In the "complete the wizard" interface, you can see the details of setting the backup:

At this point, the automatic backup of the database is set up!

Note: SQL SERVER must be started before you can perform an automatic backup of the database.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support 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.