How to Rebuild SQL Indexes Via A Maintenance Plan

 

1. Open up SQL Server Management Studio.
2. Expand out "Management".
3. Right Click on "Maintenance Plans".
4. Choose "Maintenance Plan Wizard".
5. 
6. Give your maintenance plan a name. Suggestion: Name your plan something that describes what it does. For example, you could give it the name "Rebuild Indexes on the fly".
7. Click Next
8. Check "Rebuild Index" and "Update Statistics"
9. 
10. Click Next
11. "Rebuild" should be at the top
12. Click Next
13. Choose under Databases: All user databases
14. Click Next
15. Choose under Databases: All user databases
16. Click Next
17. Note or Change the location of the report of this task
18. Click Next
19. Click Finish
20. Final screen upon successful creation 
21. Now you will have your task created under Maintenance Plans
22. Right click on your maintenance plan, it will show the name you gave it in step 6
23. Click Execute

Note: If it fails immediately check your SQL Agent, it should be green as you see below with a little play button. If it is not started do so then try 22 and 23 above again. 

 

If you have any trouble with getting this to run we will need to engage our services group as a paid engagement.

Overview

The purpose of this article is to provide the basic steps of creating a maintenance task within SQL Server which is crucial to the success of heavily coded or large databases. It is recommended to run this in accordance with your maintenance plan. A maintenance plan is suggested in our specifications guide. For a custom maintenance plan please contact our services department.