Installation manual

UNIPOWER

Installation manual PQ Secure

11 BACKUP OF DATA

PQ Secure continuously collects data from the measuring devices and stores it in the SQL database.

Because of this the value of the database increases over time and it is essential that a backup of data

is regularly made to another physical location than the server’s hard disk. This is to protect data from

external risks like theft, fire and even sabotage as well as protect data against internal risks like

program or server crashes.

In PQ Secure all critical information is stored in the SQL database and it is sufficient to make

backups only of the database.

Consult with your IT manager regarding the best backup solution.

11.1 Backup of Microsoft SQL Server

Because Microsoft SQL Server locks the database files when running (which is all the time!) normal

file backup is not possible. There are different methods available and Unipower recommends the

following methods:

 A backup software, that supports SQL Server is used. Consult with your IT administrator and

the backup supplier. With this method the SQL Server can be left running at all times.

 The SQL Server is configured to copy data at regular intervals into a backup file. This backup

file is not locked by the SQL Server and can be copied by the normal file backup system.