Database Maintenance

From WebWatchBotWiki
Jump to: navigation, search
 Share 

Summary

This menu option will perform database maintenance on the underlying Microsoft Access® database. This will compact and repair the database to ensure data integrity, performance, and minimize disk space.

Notes

  • If WebWatchBot is running as a Windows Service, a prompt to shut down the service temporarily to perform maintenance, will be displayed. If WebWatchBot is running as a Windows Application, all watch items will be temporarily suspended, without prompting, to perform maintenance.
  • Elevated permission:
    • Elevated permission is required to execute database maintenance for the user account of the SQL Server connection.
    • To find out what that user account is, open WebWatchBot Preferences (Tools -> WebWatchBot Preferences), Advanced Properties, Database. Look at the "Connection String". If there are value for UID and PWD, then that is a SQL Server user account that needs elevated permission. If there are no values and/or "Trusted_Connection" equals "yes", then the Windows user account assinged to the WebWatchBot service (WWBServer) needs elevated permission.
  • The following actions are performed during database maintenance:
    • Various SQL queries, e.g. select, insert, update, and delete
    • ALTER DATABASE
    • CHECKPOINT
    • DBCC DBREINDEX
    • DBCC ERRORLOG
    • DBCC CHECKDB
    • DBCC SHRINKFILE
    • DBCC SHRINKDATABASE
    • BACKUP
  • NOTE: during database maintenance, monitoring is stopped and no alerts will be sent during this time.