MSSQL Automatic BACKUP Database

The recent project, need to use the MSSQL automatic timing backup function, originally wanted to use C # to write one, but heard in the MSSQL2008 has integrated powerful automatic backup function, so the knife into the battle, mercilessly pondering a:

First, open MSSQL2008, and then in the Manage big class, double-click the maintenance plan subclass, which will show the task list if you have previously set up the task schedule, and if not, nothing will be displayed.

On the maintenance plan, right-click, select New Maintenance Plan, and then enter a name, where we enter the default name "Maintenanceplan" and then OK. Then, in the toolbar, in the General tab, drag the Backup database task to the design form, as shown in:

Then, in the design interface, on the backup Database task, double-click, and then pop up the dialog box, set various properties:

When the settings are complete, click OK. Then in the scheduled task, click on the right side of the calendar small icon, the automatic trigger time settings:

Then the popup box appears, in the popup box, we make the following settings:

Then, we set to every 22:38 trigger, then click OK, and finally click "Ctrl+s" to save, you will find that in the maintenance plan and SQL Server Agent job, will generate two names are:

Maintenanceplan and Maintenanceplan.subplan_1 's mission plan. Add success!

So the thing to remember is:

First of all, your backup file save path, already to exist, the database is not to give you automatically create path, otherwise will backup failed!

Second, if you set up a repeat of this task plan, then you must make the SQLAgent service automatically start state, otherwise the words are not able to automatically execute.

MSSQL Automatic BACKUP Database