Previous Next

Introducing Quest Reporter : Database Maintenance : Creating New Tasks : Data Aging Tasks

Data Aging Tasks
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.
To begin a new data aging task
Each table may be expanded to expose both the related data table and the transaction log table. Either or both of these tables may be selected. The default is to select both subsidiary tables.
The options available include:
Before: all information in the selected table that was created before the specified date will be deleted.
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.
Due to the number of operations performed during this task, Quest recommends a truncation of the transaction log file after the task is complete. For more information, see Truncate the Transaction Log.
Using the Configuration tool, it is possible to extend attributes collected by Reporter. If an extended attribute supports multiple values, the resulting database table which stores those values can not be cleaned by the Data Aging task.