Follow

How to Rebuild SQL Indexes Via A Maintenance Plan

Created by: Tod Ewasko
Created date:
Last Updated date:

Question

How do I rebuild my SQL indexes using a maintenance plan?

 

Answer

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk