Want a checklist to be used as a basis for Maintenance visits.
No checklist available.
We don't really have a maintenance checklist but some of the things you might want to consider checking on a regular basis are the items below.
Run the tests which check the database for known issues and provides a results file. See Lessons Learned Article #6226.
Review Windows Event Logs.
Check the Application and System Event logs for Continuum or SQL related errors. See Lessons Learned Article #5329.
Check the size of the ContinuumDB.
The Database can't be more than 2GB in MSDE, 4GB in SQL Express, and the size of available space on the drive if using full SQL Server. Continuum will always run better when the database is kept trim, as the database size grows, Continuum transactions may start to slow down. If general system slowness is observed then check the database size and SQL Server resources first.
Truncate/trim event tables in ContinuumDB.
Especially the ExtendedLog table which can grow very rapidly if not kept in check. See Lessons Learned Article #2107.
Check that the Continuum Workstation is patched and up to date.
Periodically service packs and hotfixes are released for different versions of Continuum to resolve identified issues. Consult The Exchange Download Center for the current updates.
Service Packs | Hotfixes
Check that Controller Firmware is up to date.
Check that the Controller firmware versions are supported for your version of Continuum and that they are up to date. Same as service packs for Continuum, new firmware builds are released as issues are identified and resolved. You can find supported firmware for each version of Continuum in the Compatibility Matrix. See Lessons Learned Article #4240.
And new firmware updates are available on The Exchange Download Center.
Check battery charges.
On controllers that have them, check that the battery for holding up the active RAM still has a charge.
How to check -> Lessons Learned Article #4482
Replacement batteries -> Lessons Learned Article #10969
Run the Continuum Errors listviews to see if there are any recurring errors that may need to be investigated.
Most Importantly!! - Backup the ContinuumDB before leaving site!
Backup and restore instructions for a single-user system are below but these also apply to full SQL Server using Management Studio. Steps 1 and 2 in the article below apply to backing up a ContinuumDB. See Lessons Learned Article #4635.