Thursday, October 29, 2020

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

1 comment:

  1. What a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these, I have new and perfect site Alondy Screen Replacement.

    ReplyDelete