Microsoft SQL Shedule Backup

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

Step 2: Create a new maintenance plan for Shedule Backup

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

Step 4: Once entered, another new window opens

Step 5:  On the Top Left corner (Marked by red color box), 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.