Maintenance Plan in SQL server 2012.

How to create scheduled Data base backup using maintenance plan in SQL server 2012.

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_1.
    
15. Click on Calendar control to change the schedule.
    
16. Click on OK 
17. 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.