Backing up a database - Metasys - LIT-12011202 - Software Application - Metasys Database Manager - 13.0

Metasys Database Manager Help

Brand
Metasys
Product name
Metasys Database Manager
Document type
User Guide
Document number
LIT-12011202
Version
13.0
Revision date
2023-08-14
Product status
Active
Language
English

About this task

Use the Backup tab to back up a database. You cannot rename a backup file. However, if you select create new file when you back up a file, the backup version does not overwrite the previous version but creates a new file and adds the date to its name.

To best preserve the data during an out-of-place upgrade, back up the databases on the old ADS, ADX, OAS, NAE85, or LCS85 immediately before the databases are needed in the new installation.

To save storage on your computer, delete database backups from the computer if the database is no longer required.

You can back up a database before purging it. Backing up a database ensures that you can restore purged data if necessary. See Purging a database for more information.

If you select create backup prior to maintenance on the maintenance tab, you must fill in the fields on the backup tab before you purge a database.

The backup tab is not available to all users. Access is dependent on the user's Windows access rights. See Required access rights for more information.

To back up a database, complete the following steps:

Procedure

  1. Open the Metasys Database Manager. See Opening the Metasys database manager to manage your databases.
  2. Click the Backup tab.
    Note: If the Backup tab is not visible, this tab may not be available to you based on your Windows access rights, or because you did not click Yes in the User Account Control window. See Required access rights and Opening the Metasys database manager to manage your databases.
  3. In the Backup File Path section, click the Browse button to choose a location for the database backup files.
    Note: The Metasys Database manager may not restore your databases from all file locations. To avoid any issues, use the default path C:\ProgramData\John Controls\MetasysIII\SQLData.
  4. Click either Create New File or Overwrite File.
  5. If you want to rebuild the SQL Server indexes, in the Database Selection section, select the databases you want to back up, and click Rebuild Indexes during backup process.
  6. Click Backup. The Backup in Progress window appears. You can ignore a Not Responding label that appears in the title bar. The back up is progressing but the page is not refreshing. Wait until the backup is complete, and the Backup Successful message box appears.