Backup and Restore Centaur Databases

Before starting, you need to understand how the Centaur databases are used and what information is saved in them. These databases are attached to the SQL Server application used by Centaur. Whenever something is programmed or an event occurs in the system, the information is downloaded to the SQL Server and saved in the Main and/or Event databases. These files are saved on your hard drive in the following default path: C:\Program Files\CDV Americas\Centaur\Centaur Server\Data. Only databases used by SQL and Centaur will be saved in the above-mentioned directory path. The backup files can be saved wherever you wish.

Main Database

The Main database (CentaurMain) contains all the system characteristics of the Centaur software (i.e. sites, controllers, schedules, cards, etc.). The more sites, cards, and controllers you have programmed, the bigger this file will be.

Event Database

The Event database (CentaurEvents) contains all events that have occurred in the system (i.e. “Access Granted”, “Door Forced”, alarms, etc.).

Step One, Using the Built in Backup Feature

See pages 178-179 of the Centaur User Manual (also below) for instructions. Create two scheduled jobs, one for the Events database, and one for the Main database. Configure the backup jobs to execute daily at 6:00 PM and 6:15 PM.

  1. Make sure the SQL Server is running (see page 11 of the Centaur User Manual).
  2. On the Centaur server, click Start, Programs, CDV Group, Centaur, Administration Console, and click MSDE Management Console. Or, from directly within Centaur, click the Open Database Backup Scheduler icon from the main menu bar. Choose the language from the pop-up window, click OK, and then the MSDE Management Console window will appear.
  3. Click the Schedule backup button from the main menu bar (near the top left corner). The Create Database Backup Wizard window will appear. Click Next.
  4. From the Database drop-down list, select the database you would like to backup.
  5. Leave the default name and description and click Next.
  6. Leave the default backup destination and click Next.
  7. On the Select the type of backup to execute page, select Create a schedule job to be performed periodically.
  8. Click Change and set the schedule to be daily at either 6:00 PM or 6:15 PM (use one time for one database backup and the other time for the other database backup).
  9. Click OK, Next, and then Finish to close out of the Create Database Backup Wizard.

Repeat this process to create backups for both of the Centaur databases.

Step Two, Copying the Database Backup Files to NAS1

Use a Powershell script (run daily at 6:30pm via Task Scheduler on Spiceworks1) to copy the database backup files to NAS1. The script is below. It is part of the Client portion of Cyrus Backup Solution and is called from Cyrus-Backup-Client.ps1.

Backup-Centaur.ps1

Start the Database Management Module*

  1. Make sure the SQL Server is running, that the Centaur Administration Console is not running, and that the Centaur Service Manager is stopped and exited.
  2. Click Start, point to Programs, CDV Group, Centaur, and click Centaur Database Manager.
  3. From the SpxDBase Logon window, type the appropriate Logon ID and Password. Centaur’s database file management utility uses the same Logon ID and Password as Centaur.

Restore Databases

  1. After starting the Database Management Module, the SpxDBase (Centaur Database Utility) window will appear.
  2. From this window, select the *Backup tab. - Select the databases you wish to restore by selecting the check boxes next to them. - Click the “…” button for each database that you will be backing up. Navigate to the database backup file and select it. - Click the Restore** button.

* Backup and restore instructions modified and taken from the Centaur Version 4.2 User Manual, Copyright (C) 2006-2008 CDVI Americas LTD

  • dr/centaur_backup.txt
  • Last modified: 2019/03/15 17:23
  • by ericclaus