SQL Database Configuration

CommandCenter uses an ODBC connection to Microsoft SQL Server. The installation creates an instance of SQL called GVSQL that works alongside other applications using MS SQL:

The database contains tables that hold different types of data, including user/groups, alarm log, status severities and program configuration. Redundant servers will automatically mirror the SQL database.

The database can be backed up or archived in the same way as any other standard SQL database using Microsoft technologies. The configuration can be backed up by CommandCenter.

The largest amount of data is used by the event log:

  • Size of online Alarm Log and the Audit Log can be controlled from configuration.
  • Automatic archiving of Alarm log can be enabled.
Note: It is highly recommended that you take a SQL class from Microsoft.
Parent topic: CommandCenter Installation

© 2014 Grass Valley USA, LLC. All rights reserved. Grass Valley is a registered trademark of GVBB Holdings S.a.r.l.