The Database Administrator application has a Backup and Restore tool. Use this utility to make a backup of your DeltaV databases. This utility is only backing up or restoring the DeltaV database files, as found in \\DeltaV\DVData\Databases\DatabaseName (where DatabaseName is the folder name of the database you are backing up or restoring). The Backup and Restore tool does not back up historical data from the Continuous Historian, event data, or process graphics. A backup can only be restored into the same version of the DeltaV software. Only the DeltaV Controller and I/O Upgrade Utility produces a file intended for import into a different version of DeltaV software.
All DeltaV applications must be closed and all locks cleared before backing up. If you back up a database with locks, those locks are also backed up. If you restore a database that was backed up with locks, the locks are also restored.
When you only want to back up your DeltaV databases, use the Database Administrator tool Backup and Restore.
The database is stored in UNC name: \\Machine Name\Databases. This is the same as the \\DeltaV\DVData\Databases folder if viewed from Windows Explorer.
When VCAT (Version Control) is enabled on the database, the Backup utility will back up the DeltaV database as well as the VCAT database. The VCAT database is a SQL database. In order to back up the VCAT database to a destination drive that is not on the SQL database machine, the MSSQLServer and SQLServerAgent services must be given access to (permissions on) the destination machine (which must have a share where the backup will be written). Therefore, the service accounts must be modified with the Service Control Manager. The accounts must be changed from the default of SYSTEM to a Windows account that has access to the destination machine (with permissions to the share and the destination folder) and is in the Administrators group on the DeltaV ProfessionalPLUS machine. An example of such an account would be the DeltaVAdmin account if the destination machine were running the DeltaV software or the destination machine had granted DeltaVAdmin access to the resource.
Restoring the DeltaV database is done when there is a problem with the database that the other Database Administrator tools (for example, Set Active Database and Register Database) cannot solve.
With the Backup and Restore tool, you can only restore the DeltaV database (controllers, I/O configuration, and control strategy). You are not restoring the entire DeltaV system.
The database is normally stored in UNC name: \\Machine Name\Databases. This is the same as the \\DeltaV\DVData\Databases folder if viewed from Windows Explorer.
If you restore the database to a different machine or under a new name, you need to set the server host machine, set the active database, and synchronize the workstations.
The Objectivity Database contains the control configuration data that defines the workstations, controllers, and modules that run in the controllers. The display data consists of the operator displays.
It is required that you exit all DeltaV Engineering Tools before running a backup of the active configuration database. These tools access the configuration database, and the integrity of a database backup is not guaranteed while any of these tools are open. An error dialog appears during the backup if there are open programs. To determine which programs are open, double-click Database Connections in Database Administrator.
Exit the DeltaV Engineering tools before restoring the database. Use Database Connections if necessary.