Database Considerations
- Alberto Brunoni (Unlicensed)
IP Server saves configuration settings, user names, camera information and event logs in a Microsoft SQL Server database. When IP Server starts, it reads its settings directly from the assigned database.
IP Server saves all video recordings to its local hard drives, SAS/NAS storage device so video recordings are still accessible in case of a SQL database failure.
The following table can be used to determine whether a local or shared database is required:
Local Database | Shared Database |
|---|---|
Small centralized organization with 1-3 servers. | Large regional organization with many servers. |
Use VI MonitorPlus client and built-in User Manager. | Use Active Directory/LDAP. |
Disaster recovery and backup for each server’s database. | Disaster recovery and backup for one database. |
Failover server functionality is not desired. | Failover server functionality is desired. |
Cameras will not move from one server to another. | Cameras will move from one server to another at final configuration. |
Avoids unnecessary exposure of SQL database to the network. | Exposure of SQL database to the network in a secured network environment. |
Â