Database Maintenance

Honeywell recommends that you run a full backup of your VoiceCheck database daily during off hours. Along with the backup job, you should backup the transaction log and rebuild all database indexes.

If you support more than 500 technicians, you may need to perform special maintenance on the core_assigment and core_assignment_check database tables. Honeywell recommends reorganizing the index based on the volume of assignments and steps and the rate of transactions performed on these tables.

SQL Server provides tools to configure these maintenance jobs and has an index report for monitoring the health of database indexes. This report can help you determine the frequency at which the indexes should be reorganized or rebuilt.

Honeywell recommends that a database administrator monitor the system during the first week of heavy use to determine an optimal indexing strategy.

If your VoiceCheck database service goes down or requires a restart, you must also stop the VoiceCheck application service. Start the application service again only after the database is fully up and running.