Quick Maintenance & Backup for MS SQL
Wizard for running recommended operations
| Database maintenance settings > Wizard for running recommended operations |
When needed, the program prompts the user to run one or several procedures (usually after a policy has been created or edited). This opens a wizard that allows you to:
Setting a Recovery Model
Create a full database backups
In most cases, you will need to create a full backup prior to starting regular maintenance.
If you click the Databases link, a window will open. The form allows you to select databases to be backed up, view the current recovery model and the date of creation of the latest full backup.
The form for choosing a database on which a backup will be created |
If the creation of a full backup is not required, uncheck the Create a full database backups option.
Resetting the 'Auto Close' Property.
Setting the Auto Close property to True for operating databases is a bad practice. The program will prompt you to set this property to the value False.
When proceeding to the next step, the assistant will start running the procedures.