Previous Next

Introducing Quest Reporter : Database Maintenance : Creating New Tasks : Maintenance Tasks : Rebuilding Table Indexes

Rebuilding Table Indexes
This task rebuilds the indexes for all of the tables in the selected database. It requires no parameters other than the scheduling of the task.
Quest Reporter will switch to the Simple mode of transaction logging (see Set Database Recovery Model.) during this task to avoid the creation of excessively large log files. When the task is complete, Reporter will return the transaction logging to its previous value.
The execution of this task is very resource intensive and it will block access to tables whose indexes are being rebuilt. Quest strongly recommends scheduling this task while the database is offline or during off-peak hours.
To rebuild table indexes
Select Rebuild All Table Indexes.
Click Next.
Enter the user name and password that will be used to access the database, including the domain in the form domain\username if necessary, and click Next.
Either choose among the provided options or click Advanced for more detailed options.
If you want an email to be sent when the task is complete, check the box labelled Send an email message when the task finishes and provide the required information in the text boxes provided.
Click Next.
The task will be added to the list of tasks in the upper pane of the Maintenance tab.