You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

DW Spectrum Server Database files

The DW Spectrum Server uses a combination of database technologies to accomplish its amazing feats. Below we outline the details of each database required in order to keep your DW Spectrum System up and running.

*NEVER modify database files in a System without express direction from the DW Spectrum Support Team.  

---------------

System Database (SQLite, synchronized)

The System Database is the main database that keeps a System up and running. When you create a backup of your System's database - this is what gets backed up.

Database Technology: SQLite
Synchronization: No

Contents:

  • User Rights & Settings
  • System Settings
  • Device Configuration

Database Location: 

  • Windows
    \Windows\System32\config\systemprofile\AppData\Local\dwspectrum\DW Spectrum Media Server\ecs.sqlite

     
  • Ubuntu
    /opt/ dwspectrum /mediaserver/var/ecs.sqlite

---------------

Server Database

The Server Database is a local database that keeps track of all events, bookmarks and operator actions. It's local for every Server and is not synchronized.

Database Technology: SQLite
Synchronization: No

Database Location: 

  • Windows: C:\Windows\System32\config\systemprofile\AppData\Local\DW Spectrum \DW Spectrum Media Server\mserver.sqlite
     
  • Ubuntu: /opt/dwspectrum/mediaserver/var/mserver.sqlite

---------------

Archive Index (not synchronized)

Database Technology: .NXDB (proprietary)
Synchronization: No

Contents:

  • Storage index for recorded video (used for recall and timeline)

Location:

  • Next to recorded archives (on the same drive)

---------------

Smart Motion Index (not synchronized)

DW Spectrum Server keeps Smart Search index files for all recorded video in a binary format. They're also not synced across the system and are local to the Server. Server reports this information to the rest of the System while it's online. Files are used for Smart Motion Search with a spyglass at DW Spectrum Desktop.

Database Technology: Index Files in Binary Format
Synchronization: No

  • 81
  • 03-Apr-2019
  • 1231 Views