Back up log server database, Manual backup and restore – Milestone XProtect Advanced VMS 2014 User Manual

Page 268

Advertising
background image

Milestone XProtect

®

Advanced

VMS 2014

Administrator's Manual

www.milestonesys.com

268

System maintenance

The system offers a built-in feature that backs up all the system configuration you can define in the
Management Client. Note that the log server database and the log files, including audit log files, are
not included in this backup.

If your system is large, Milestone recommends that you define scheduled backups. This is done with
the third-party tool: Microsoft® SQL Server Management Studio. This backup includes the same data
as a manual backup.

During a backup, your system stays online. Depending on your system configuration, your hardware,
and on whether you have installed the SQL server, Event Server service and Management Client on a
single server or several servers (a distributed setup), backing up the system configuration can take
some time.

Each time you make a backup both manual and scheduled, the SQL Server's transaction log file is
flushed. For additional information about how to flush this log file, go to

http://www.support.microsoft.com

and search for "SQL Server transaction log".

Back up log server database

Handle the SurveillanceLogServer database by using the method that you use when handling
system configuration as described earlier. The SurveillanceLogServer database (the name may be
different if you renamed the system configuration database) contains all your system logs, including
errors reported by recording servers and cameras.

The database is located where the Log Server's SQL server is installed, typically the same place as
your management server's SQL server. Backing up this database is not vital since it does not contain
any system configuration, but you may later appreciate having access to system logs from before the
management server backup/restore.

Manual backup and restore

About manually backing up your system configuration

When you want to perform a manual backup of your system configuration, make sure that your system
stays online. Here are a few things to consider before you start the backup:

You cannot use a backup to copy configurations to other systems.

It can take some time to back up your configuration. It depends on your system configuration,
your hardware, and on whether your SQL server, management server and Management Client
are installed on the same computer.

Logs, including audit logs, are not part of the configuration backup.

About backing up and restoring the event server configuration

The content of your event server configuration is included when you back up and restore system
configuration.

The first time you run the event server, all its configuration files are automatically moved to the SQL
server. You can apply the restored configuration to the event server without needing to restart the
event server, and the event server can start and stop all external communication while the restoration
of the configuration is being loaded.

Advertising