ConfigMgr Database Re-Index

Question

Hi,

Please let me know how to perform ConfigMgr Database re-index.
And is there any backup of database required before the ConfigMgr Database re-index.

Regards,
Boopathi

Answer 1

AFAIK Ola Hallengren's script is still one of the best ways to achieve this. Here is an install guide from Garth Jones
https://www.recastsoftware.com/resources/installation-guide-to-ola-hallengrens-sql-server-maintenance-solution/

I would backup the database prior.

Answer 2

Hi @Boopathi S ,

Thanks for posting in Microsoft Q&A forum.

To enable the Database Rebuild Index, we could go through this path: Site > Site Maintenance > Edit the Maintenance task

For more details, we could refer to the following articles:

1. How to set up Maintenance task:
   https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/maintenance-tasks#bkmk_MTs1906
2. Maintenance task: Rebuild Index
   https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/reference-for-maintenance-tasks#rebuild-indexes

Hope the above information can help you.

---

If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.