Restore tab - 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

The Restore tab is available only when you are using the Metasys Database Manager in Expert Mode. If you cannot see this tab, see Required access rights.

If you are performing an out-of-place upgrade, use the Restore tab to restore historical databases. The Restore tab also provides a simple way to recover if your Metasys system database becomes corrupted. Perform a restore only if there is no alternative, and use the most recent successful backup file.

Important:

Restoring a database deletes any information that is in the database from the time the backup was created to when it was restored. Use this option to restore a database during an out-of-place upgrade, or to repair a corrupted database only. This feature should not be used to view historical data in the Metasys system. Instead, use the Metasys Export Utility to store and view historical data in more user-friendly formats.

You cannot restore database backups from a newer version of SQL Server software to an older version of SQL Server software. For example, you cannot create a backup of Metasys databases that are hosted on SQL Server 2019 software and restore them to SQL Server 2016 software. However, you can restore database backups from an older version of SQL Server to a newer version of SQL Server. If you restore a database that was created using a version of SQL Server software that is older than the version you are currently using, the Metasys Database Manager upgrades the database so it can function with the current SQL Server software version.

If you restore a database from a release of Metasys software that is earlier than the software that you are using, the ADS, ADX, OAS, NAE85, or LCS85 stops functioning. No fail-safes prevent you from restoring a database that is older than the database you are using. Be sure to restore databases from the same release that you are using if the ADS, ADX, OAS, NAE85, or LCS85 is already installed.

If you are not performing an out-of-place upgrade as detailed in the Metasys Server Installation and Upgrade Instructions (LIT-12012162) , you cannot restore a database from a system that does not have the Metasys Advanced Reporting System installed to a system that does have the reporting system installed. The database does not contain all the stored procedures required to use the reporting system. If you attempt to do this, the reporting system does not function.

Do not restore databases from a different server unless you follow the process for performing an out-of-place upgrade as detailed in the Metasys Server Installation and Upgrade Instructions (LIT-12012162) . Even if both systems have the same name and are at the same Metasys release, there are underlying differences in the databases.

See Interaction with the Metasys system for information on ADS, ADX, OAS, NAE85, or LCS85 behavior during database restoration.

The Restore tab opens with a warning that offers the choice whether to continue with or cancel the restore. Clicking Continue proceeds with the restore and Figure 1 appears.

Figure 1. Restore Tab

The Backup File field allows you to browse to the database you want to restore to the ADS, ADX, OAS, NAE85, or LCS85. Once a backup file is selected, clicking Restore Now starts the database restore. See Restoring a database.