User Tools


Background

MeasureColor stores its data in an MSSQL Server database. Over time your database grows and gets more and more value because of the historical data that it holds. Therefore it is good practice to create regular backups of the database.

Backing up your database

This document describes SQL backups in general and provides an easy method to create basic backups and restore for your database using a free to use utility.

Important note:

Colorware holds no responsibility for database integrity, security, maintenance, backup and restore procedures. This document is provided as additional help pointing to one or more methods on how to secure your data. It is advised that a trained system engineer monitors and manages your system at all times.

Advanced backup and restore procedures:

System managers and expert users might find valuable information on advanced backup and restore procedures from the Microsoft MSDN here: - http://msdn.microsoft.com/en-us/library/ms187048%28v=sql.105%29.aspx . Please note this link leads to a SQL 2008 R2 document but provides links to other SQL versions. Please select the page of your current SQL install.

For MSSQL Server, the database is stored by default in the SQL Server directory inside your Program Files directory. Please check and make sure that your backup system has added this location to the daily backup routines.

Easy backup and restore for your MeasureColor database

Colorware provides a basic database backup utility that can make a back-up to a folder on the same machine with just a few mouse clicks:

http://labs.measurecolor.net/