在MS SQL Server 中创建计划备份

Step 1: Open Object explorer and select “Management” -> Maintenance Plans

Step 2: Create a new maintenance plan

Step 3: A new window pops up asking for the name of the plan.

Step 4: Once entered, another new window opens.

Step 5: On the Top Left corner, from the Maintenance Plan Tasks, select “Back up Database Task”.

Step 6: Drag and drop “Back up Database Task” to Design part

Step 7: Double click the Box and a window opens as follows:

Step 8: Select the Database to be taken back up .

Step 9: Select the folder where the database has to be taken back up and also enter the frequency when the database back up has to take place.

Click OK and the database schedule job is done.