Previous Next

Introducing Quest Reporter : Database Maintenance : Creating New Tasks : Maintenance Tasks : Shrink Data and Log files

Shrink Data and Log files
This task shrinks the data and log files according to the parameters provided. Options include shrink and truncate, no truncation of the files, and only truncating the files. Additionally, the administrator specifies the desired percentage of free space required and the tool will attempt to reach that goal.
Note that once a shrink operation has begun, it can not be stopped. Stopping a shrink in mid-operation may result in data loss.
To shrink the data and log files
Select Shrink all Data and Log Files.
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.