GE v6 - Manual (Page 133)

Secure Perfect 6.1.1 User Manual 131
D
Database Tab - Reports
Alarm History, Badge History, Zone History, DI History, Time and Attendance, or Operator History
Reports
Use this tab to select the history database to use for this report. The file name displayed on the tab is the
currently selected archive database.
• Select archive database: Click to select the archive history database.
• Use default: Click to use the current history database.
Database Utilites
The Integrity utility runs automatically, following a database creation or conversion and upgrade from a
previous version of Secure Perfect. No user interaction is required.
The utility can be run manually if you want to check your database integrity. The system compares and
validates the integrity of your database schema. If selected, the system will automatically correct missing
or incorrect schema properties such as columns, keys, constraints, indexes, triggers, and tables. The
executable file is installed with Secure Perfect and resides in the
Secure Perfect
program folder.
1. Locate and double-click the
DatabaseIntegrity.exe
file to manually run the utility.
2. Enter the Server Name or click the browse button and navigate to the appropriate Server Name.
3. Enter the SQL system administrator ‘
sa
’ Database Password or accept the encrypted database
password of the default Server.
4. Click Connect to locate and connect to the Secure Perfect databases. The remaining selections are
now enabled. Accept the default options or review and disable selections.
5. Select one of two options:
Verify that Check Database Integrity is selected.
OPTIONAL: Select the Autocorrect checkbox. This feature runs only once and
corrects obvious schema in the database. Results display in a report.
Autocorrect is not available on a Global Edition system.
Select which databases to check.
Select Start to begin. Wait as the Database Integrity tool compares and validates the
integrity of your database. Messages generate to an
IntegrityCheck.html
file in
your Secure Perfect application Logs folder.
OR
Select Unlock Database Mutex to unlock the shared resource. Select Unlock to
unlock the database mutex for SPSQL.
6. Click OK when the Application Success window displays.