About the Metadata Server Backup Facility

The SAS 9.3 Metadata Server includes a new server-based facility that performs metadata server backups automatically, on a scheduled basis, without the need for administrator intervention. This facility can also be used to perform ad hoc backups and to perform roll-forward recovery. The facility replaces the %OMABAKUP macro, which was available in SAS 9.1 and 9.2, and the Backup and Restore Wizard in SAS Management Console, which was available in SAS 9.2.
The backup facility backs up all registered metadata repositories, the repository manager, and the metadata server’s configuration directory. By default, backups are scheduled to run at 1:00 a.m. daily. Administrators can change this schedule as needed. Backups can also be launched from SAS Management Console, from the operating system command line, from SAS, or through third-party scheduling software.
The metadata server backup facility provides the following advantages:
  • The backup facility executes in a separate thread while the metadata server is running. Therefore, the server does not need to be paused during backups unless certain options are selected. When repositories are restored in the event of a metadata server failure, transactions recorded in the journal file can be used to perform roll-forward recovery to a specified point in time after the last backup was taken.
  • The metadata server runs its own backup and recovery processes and does not rely on any other servers. Because the metadata server has permission to access all of the needed files, there is no need to set up a host account with special operating system rights and permissions.
  • The backup facility automatically includes all of the metadata server’s data sets, including the repository manager, all of your registered metadata repositories, and the individual files that are stored in the metadata server configuration directory (SAS-configuration-directory/Lev1/SASMeta/MetadataServer).
  • SAS Management Console displays a detailed history of backups that were performed using the backup facility. Status icons indicate which backups are active and which backups have been deleted based on the retention policy. When you view the properties of a backup, the backup files are validated, and the status icon is updated to indicate whether the backup is usable.
  • When repositories are restored in the event of a metadata server failure, transactions recorded in the journal file can be used to perform roll-forward recovery to a specified point in time after the last backup was taken.