Backing Up and Recovering the SAS Metadata Server

It is important to make regular backups of your SAS metadata repositories. The SAS Metadata Server locks repository files, so you cannot use operating system commands to back up a running SAS Metadata Server unless you stop the server or change it to an OFFLINE state before you back up the files.
The SAS 9.3 Metadata Server includes a server-based facility that can be used to perform unassisted, scheduled SAS Metadata Server backups. Because the facility is run by the server (in a separate thread), the following is true:
  • Backups can run without interrupting the regular operation of the SAS Metadata Server.
  • There is no need to obtain operating system access to SAS Metadata Server directories or to configure a special account for backup processing.
  • There is no need to obtain appropriate authorization to metadata to back up the SAS Metadata Server.
The facility can be used to perform ad hoc backups, restores, and roll-forward recovery of the SAS Metadata Server from the metadata server journal. A client must have administrative access to the SAS Metadata Server to perform these tasks.
This facility replaces the %OMABAKUP macro that was provided to back up and restore the SAS Metadata Server in SAS 9.1 and SAS 9.2.
The SAS Deployment Wizard uses this facility to configure a default schedule of unassisted metadata server backups for all new and migrated SAS 9.3 systems during installation. The SAS 9.3 Management Console Metadata Manager provides a graphical user interface to enable customers to monitor and manipulate backups, modify the default backup configuration and backup schedule, perform ad hoc backups, and perform metadata server recovery. A MetadataServer script in the SASMeta/MetadataServer directory provides a batch interface for the functionality available in SAS Management Console.
Lower-level access can be obtained by using metadata procedures, such as PROC METAOPERATE and PROC METADATA, or by issuing IServer Refresh and Status method requests. However, using metadata procedures and issuing method requests are not necessary. Directly using the IServer Refresh or Status method is discouraged. The recommended interface for manipulating, administering, and monitoring server backups is SAS Management Console.
For information about manipulating, administering, and monitoring server backups with SAS Management Console, including best practices for incorporating server backups into the overall backup plan for the SAS Intelligence Platform, see the SAS Intelligence Platform: System Administration Guide. The MetadataServer script is also documented in the SAS Intelligence Platform: System Administration Guide.
For information about administering server backups with PROC METAOPERATE and monitoring server backups with PROC METADATA, see the SAS Language Interfaces to Metadata. IServer methods are described in Server Control (IServer Interface).