User Tools


Database warning settings

All important data in MeasureColor such as References, Presets, Jobs, Measurement conditions, Measurements are stored in a Microsoft SQL database. From version 17.2.xx and later MeasureColor warns you for low HDD space or exceeding the SQL EXPRESS limits (if applicable) on login.

Important note:

Colorware holds no responsibility for database integrity, security, maintenance, backup and restore procedures. It is advised that a trained system engineer monitors and manages your system at all times.

Starting point

The warnings are configurable to your situation but we wanted to give you a sensible starting point:

SettingGeneral advice
Throw HDD warning upon login when the drive is reaching its maximum capacityEnable at all times
Throw a warning when HDD has less than this percentage available5..20 %
Throw warning upon login when reaching the limit of SQL EXPRESSenable when you use the default SQL license*
*By default, we install Microsoft SQL Server 2014 Express. SQLServer comes in different flavours to meet demands for different types of customers. The Express version has a database limit of 10GB (GigaByte) while commercial licenses of the database server support a nearly unlimited storage capacity of 524PB (PetaBytes). More information on Microsoft SQL Server versions can be read here: Background information on database growth

Examples

Warning when the HDD space is set to 20% and the disk is almost fullWarning when SQL EXPRESS is near its data limit

Counter actions

  • When the Server disk space warning is thrown consider expanding the available disk space or deleting unused files if possible.
  • When the database space warning is thrown delete old jobs or (if you use the same job for a prolonged time) delete old measurements. Read more about doing that the easy way here: Database cleanup