Database

Mirasys VMS use a Microsoft SQL Express server to store data.

DvmsData

This database includes these tables

• dbo.AlarmAction

  • VMS alarm actions

• dbo.AlarmConfig

  • VMS alarm configurations

• dbo.AlarmEvent

  • VMS alarm events

• dbo.AuditTrail

  • VMS system audit information

RecorderDB

This database includes these tables

• dbo.Edge

  • DVRServer stored here camera channel details when the system has lost connection and re-established it

  • With these details, DVRServer can receive missing material from camera SD-card

• dbo.RecorderMetadata

  • DVRServer stored here Mirasys Metadata

  • This metadata can be used showing zones etc. on stored material

WdContext

This database includes these tables

• dbo.__MigrationHistory

  • WDServer migration history

• dbo.WdEvents

  • WDServer store here system Watchdog Events

Failover

This database includes these tables

• dbo._MigrationHistory

• dbo._FailoverLogEntryDbs

Master Server

When the VMS system includes a Master server, this server gather these details from servers to own databases

• DvmsData

  • dbo.AlarmAction

  • dbo.AlarmConfig

  • dbo.AlarmEvent

• WdContext

  • dbo.WdEvents

The master server uses its own dbo.AuditTrail storing information.