Automatic backup of SQL Server databases

Page creation date :

Start SQL Server Management Studio, expand the Administration folder from Object Explorer, right-click Maintenance Plan, and then select New Maintenance Plan.

管理 - メンテナンス プラン - 新しいメンテナンス プラン

Enter a descriptive name and click the "OK" button.

新しいメンテナンス プラン

A new maintenance plan is created and the designer is displayed.


Open the Toolbox and select Database Backup Tasks.

ツールボックス - データベースのバックアップ タスク

Place it on the designer. Double-click the task that you placed to specify which database to back up.

データベースのバックアップ タスク

The database backup task settings screen is displayed.

データベースのバックアップ タスク

Select Databases and select the database you want to schedule backups for. If necessary, specify other parameters, such as the destination folder for the backup.


Once you have confirmed by pressing the OK button, specify when you want to perform the backup next time. Click the calendar icon for the schedule in the subplan.


Here you can schedule how often and how often backups are started, and when to start. Specify the timing you want to back up and confirm it with the OK button.

新しいジョブ スケジュール

Once you have specified a schedule, you are done. Make sure that the database is automatically backed up at the specified time.

By the way, this maintenance creates a job for SQL Server Agent internally, and you can see that if you look at the job because you are simply running it, you can see that the backup task you created has been added.