Previous Next

Introducing Quest Reporter : Database Maintenance : Creating New Tasks : Maintenance Tasks : Set Database Recovery Model

Set Database Recovery Model
This task sets the database recovery model which controls the transaction log maintenance. There are three options which are detailed below.
Simple: Automatically reclaims log space to minimize space requirements. This option eliminates the need to manage the transaction log space. This option also allows recovery only to the most recent backup point.
Full: This option maintains full log backups and allows recovery to an arbitrary point in time.
Bulk Logged: This option uses minimal logging for bulk operations to reduce log space usage. Recovery is possible to any backup point.
Since Quest Reporter can recollect any lost data, the risk of data loss is low. As a result, Quest recommends using the Simple database recovery model if you wish to conserve log space.
To set the Database Recovery Model
Select Set Database Recovery Model.
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