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”.



5. Now you will welcome wizard



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

 

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



10. Click on 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



14. Double click on 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,