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.
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.
No comments:
Post a Comment