sql_server2005 automatic backup and removal-maintenance plan

Business background:

In order to facilitate the timely automatic updating of the SAP library data and reduce disk space. So you want to automatically back up and delete the data in SQL. This makes it easier for administrators to manage and reduce the workload of administrators.

Solution Ideas:

In 2005 SQL environment, create automatic backup and automatic deletion.

Solution:

1. Click "Manage", select "Maintenance Plan", right click and select "New Maintenance Plan (N)", the following two figure:

2. Click "New Maintenance Plan" to pop up the dialog box, name the maintenance name, and then click "OK", such as:

3. Drag the Backup database task from the left bottom toolbox to the right margin, then right-click to select Edit, such as:

4. Select "Edit" to pop up the dialog box; Select the database you want to back up.

5, set up the path of backup, click OK, Task creation is complete. Next, create a plan to change the task.

Execution time can be set to monthly, weekly, daily, according to the relevant circumstances to choose the appropriate time! (because the backup consumes server resources, it is recommended that you choose the time off.) In general, we will define it as 0 points later. ）

6, check your settings, open the backup folder to see if there is a backup file.

7. Create a Delete backup file

1) The task added here is clear history task

2) Edit the task

3) automatic deletion of backup files for more than four weeks

sql_server2005 automatic backup and removal-maintenance plan