DB Backup using maintenance plan in SQL server 2012

In this blog we will learn how to create scheduled Data base backup using maintenance plan in SQL server 2012.

Steps

1. Check the SQL server agent service is running or not, if not then start the service.
2. Login to the SQL server.
3. Expand the Management node.
4. Right click on Maintenance plan node and select the “Maintenance Plan Wizard”.

Maintenance Plan Wizard

5. Now you will welcome wizard

welcome wizard

6. Click on Next.
7. Enter the Name .and Description and select “Separate Schedule for each task”

Separate Schedule for each task 

8. Click on Next
9. Select the Backup Database full.

Backup Database full

10. Click on Next button.

Next button

11. Now select the database which we want to take backup and change the file location.





12. Click on Next-> Next -> Finish.
13. Now double click on the Maintenance plan

Maintenance plan

14. Double click on Sub plan.

Sub Plan

15. Click on Calendar control to change the schedule.



16. Click on OK -> Ok.

Now DB backup maintenance plan will execute as per schedule and if you want to execute manually just right click on the Node and click on execute.

Thanks,
Ebook Download
View all
Learn
View all