...
Select the tasks you want to perform each time the maintenance plan runs, then select Next. (A description of each task displays when you select its corresponding check box.)
Note
Each customer’s selected maintenance tasks may differ from the following illustration.
...
Select Check Database Integrity, then select Next.
Select the FactoryLogix database you want to perform an integrity check on, select the check box for your database, select OK, then select Next.
Select the database to have the indexes reorganized, select the check box for your database, select OK, then select Next.
Select Tables and views from the Object drop-down to configure the Reorganize Index task, then select Next.
Select the database you would like to rebuild indexes, select the check box for your database, then select OK.
Select the desired settings for the History Cleanup task, then select Next.
Select the database you are backing up, select the check box for your database, then select OK.
Note |
---|
Warning The default path for database backup is the installation path for SQL Server. We recommend that you do not store the backup on the system drive or on the same drive where the database resides---if either of these drives fail, you will lose the backup! |
...