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.
- 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
- DBCC DBREINDEX
- DBCC ERRORLOG
- DBCC CHECKDB
- DBCC SHRINKFILE
- DBCC SHRINKDATABASE
- NOTE: during database maintenance, monitoring is stopped and no alerts will be sent during this time.