METAOPERATE Procedure

Example 8: Submitting ACTION=REFRESH with Backup and Recover Options

Features:

ACTION=REFRESH argument

OPTIONS= argument with <BACKUP/>, <BACKUPCONFIGURATION/>, <SCHEDULE/>, and <RECOVER/>

Note:

You must be an administrative user of the metadata server to perform this action.

To execute an ad hoc backup of the SAS Metadata Server:This example includes the COMMENT= attribute.

proc metaoperate
  action=REFRESH
  options=
    "<Backup Comment='Test of backup system.'/>"
    noautopause;
  run;

To modify the backup configuration:

proc metaoperate
  action=REFRESH
  options=
    "<BackupConfiguration DaysToRetainBackups='4'/>"
   noautopause;
  run;

To modify the default backup schedule:

proc metaoperate
  action=REFRESH
  options=
    "<Schedule Event='Backup' WeekDay1='0200' WeekDay2='0200R' WeekDay3='0200' 
 WeekDay4='0200' WeekDay5='0200' WeekDay6='0200' WeekDay7='0200'/>"
  noautopause;
 run;

To recover the metadata server:

proc metaoperate
  action=REFRESH
  options=
  "<Recover BackupPath='Backups/2010-09-16T16_14_36-05_00' IncludeAllConfigFiles='N' 
RollForward='16Sep2010:16:22:30' PauseComment='The metadata server is being recovered.' 
Comment='Recovery from 2010-09-16T16_14_36-05_00'/>"
   noautopause;
  run;

To terminate a hung recovery process, and then put the metadata server in an ADMIN state:

proc metaoperate
	action=PAUSE
	options="<Server State='ADMIN'/><Force/>";
run;