Configuring Database Maintenance Settings

The Database Maintenance utility lets you configure settings that are used during compact, convert, and copy operations.

The backup settings in the Configure operations for maintenance system dialog box apply to Microsoft Access databases only. To configure backup settings for other types of databases used as a Silk Test Workbench database, refer to the product documentation of the specific database.

When a database is compacted or converted, the current version can be backed up. Use the Configure operations for maintenance system dialog box to specify the maximum number of backup copies to retain. If you specify that you want to retain three compact or convert backups, each time you convert or compact a database, one new backup is created. After three backups are created, the next time you convert or compact, the oldest backup is deleted to enable a new backup to be added.

Select the number of records to buffer during a transaction. A transaction is the process of writing a large amount of data to the database in cycles to improve performance. Each database operation is buffered, until the transaction is committed to the database. However, if any operation fails, then all operations in that transaction fail. You can specify the number of operations to buffer before saving the data to the database.

  1. Ensure that all users are logged off the system and close Silk Test Workbench.
  2. Start the Database Maintenance utility and open the database.
  3. Choose Options > Configure. The Configure operations for maintenance system dialog box opens.
  4. Double-click the options in the Settings tab to specify the number of backups to retain from compacts and conversions, to set the number of records to commit, and to specify the number of seconds before a query attempt fails.