Citadel Database Backup and Read From Another Computer

Updated Mar 27, 2023

Reported In

Software

  • Measurement & Automation Explorer (MAX)
  • LabVIEW Datalogging and Supervisory Control Module
  • Lookout Server

Other

  • Citadel 5 Database

Issue Details

I am logging data to the Citadel database on my production PC.  However, I want to have a way to backup the whole database so that I can look at the traces from another PC if anything ever happens to this computer.

Solution

You can move a Citadel database from one computer to another computer using two methods: 
 

Detaching Database and Copy to Another Computer

Detach Database

  1. Make sure this database is still not actively in use when we are detaching and copying it.
  2. Navigate to your Citadel database in NI MAX.
  3. Right-click on your database >> Detach/Delete... 
  1. In the dialog that comes up select Detach and click OK.
 
 
  1. The database is now detached.

Move Database to Another Computer and Attach

  1. Go to the location of the database directory on disk and copy it over to your other computer via whatever means you choose (network mapped drive, USB drive, DVD, CD, etc...)
  2. Open NI MAX on your destination computer >> My System >> Historical Data >> Citadel 5 Universe
  3. Right-click on My Computer under Universe and select Create/Attach Database... 
  1. A window should pop up.  Click on the ... to browse for the path of your database. 
 

 
  1. Select your database folder and click OK

 
  1. Check to make sure your path is correct and select OK

 
  1. You can now see your database is attached to this computer's Citadel database and can be seen in NI MAX.  You can now access the database traces from NI MAX as well as LabVIEW.

 
Archiving Database to Another Computer

For this method to work, your two computers have to be connected to each other over the network.

Prepare destination computer

  1. In NI MAX of the computer you want to copy your database to, navigate to My System >> Historical Data >> Citadel 5 Universe.  
  2. Right-click on My System on the right panel >> Create/Attach Database... 

 
  1. A window should pop up.  Click on the ... to browse for the path of where you want the database to be copied. 
  1. Select the folder where you want the database to be copied or create a new folder and click OK
 
  1. Check to make sure your path is correct and select OK
  1. This new database or folder location has now been added to your Citadel Universe in NI MAX.

Archive database from one computer to the other

  1. In NI MAX, navigate to your Citadel database that you want to export.
  2. Right-click on your database >> Archive...
  1. Select the database(s) that you want to archive and click Next.  You can choose which ones you want to archive by using the Add and Remove buttons.  Check the bottom window to make sure you have all and only the databases you want archived selected. 
 
  1. Go to Universe >> Network and find the computer you want to archive your database(s) to.  Select the database and click Next.
 
  1. Select the time range that you want to archive.  By default, there is no time filter.  Click Finish.
  1. The database will now be archived to your destination location and can be seen in NI MAX on the destination computer.  You can now access the database traces from NI MAX as well as LabVIEW.

Additional Information

If you are continuously backing up your database, you may want to look at the steps for merging Citadel databases if you do not want to potentially have multiple copies of your database on your backup computer.