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

Backup of SQL SERVER database is a means to ensure daily data security. In addition to manual backup, we should also make a backup plan for this daily data security backup so that the database can be backed up automatically on a regular basis. Through the SQL maintenance plan, you can easily maintain the backup files of the database to preserve the integrity of the database data. First, backup 1. New maintenance Plan Management-> maintenance Plan-> New maintenance Plan

a. Create a new maintenance plan and set the name

b. Toolbox drag the backup Database task to the designer interface

two。 Edit backup database task right-click Edit

You can set it as needed, select the backup type, backup database, select the directory to which you want to backup, check to verify the integrity of the backup, and so on.

3. Set job task properties

Set plan type, frequency, etc.

Clean up historical backups on a regular basis

The first few procedures are the same as backup, drag the clear maintenance task from the toolbox, and edit

There are two points to pay attention to here.

1. Search folder here, do not support recursive search, if there are multiple directories need to create multiple tasks, separately set to the directory

two。 The file extension is "bak", do not write ".bak", this is not recognized

Finally, set the plan type, frequency, etc.

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.