Running Maintenance

<< Click to Display Table of Contents >>

Navigation:  Database Schemas > Schema Database Maintenance >

Running Maintenance

*Screenshots are from the UltraPort SQL Schema Engine version 5.2.3

 

Maintenance on your schema tables can be run TWO different ways.

 

If enabled in your Global Settings you can register the maintenance service (professional license only), start it and maintenance will be running in the background all the time.

 

Windows Service Status Information

Windows Service Status Information

 

You can also run your maintenance plans "locally" right from the configuration program by clicking the "Service Status" button on the main toolbar and then clicking the "Run DB Maintenance" button. Doing it this way allows you to control exactly when maintenance is run and also allows you to stop maintenance when it is completed.

 

Database Maintenance Window

Database Maintenance Window