Back up a database

  1. Double-click the Backup and Restore tool.
  2. In the Database name field, click the down arrow and select the name of the registered database you want to back up.
  3. Click Backup.
  4. Select a directory in which to store the backup. This must be a UNC path. Replace any mapped drives with the appropriate UNC path for that destination (that is, \\machinename\sharename\foldername).
    Note

    When VCAT (Version Control) is enabled on the database, the Backup utility will backup the DeltaV database as well as the VCAT database. The VCAT database is a SQL database. Backing up the Version Control (VCAT) database to a destination drive that is not the SQL database's drive requires the MSSQLServer and SQLAgent services to have access to (permissions on) the destination machine (which must be a share) to perform the backup. In this case, 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 access to the share and to the destination folder) and is in the Administrators group on the DeltaV machine. An example of such an account would be the DeltaVAdmin account if the destination machine is running DeltaV or if the destination machine has granted DeltaVAdmin access to the resource.

  5. If you want, add a comment about this backup database.
  6. Click OK.
    If you do not want to accept the default file name for the backup file, you can change the name before you click OK.
  7. In the Confirm dialog, click Yes if the database name and directory path are correct.
    The system informs you if there are users connected to the database. You cannot backup the database with users currently connected.