spdsrstr -d <domain> -h <host> {-f <fullfile>|-e <extfile>}[-hash][-r <count>]
[-a |-aforce][-aonly][-n][-q][-s <service>][-u <user>][-p <password>]
[-proj <directory>][table ...]spdsrstr -t {-f <fullfile>|-e <extfile>}[table...]spdsrstr -v -d <domain> -h <host> {-f <fullfile>|-e <extfile>}[-s <service>]
[-u <user>][-p <password>][-proj <directory>][table ...]restores all or selected tables from a backup file.
prints a table of contents for a backup file. This table of contents file reports when the backup file was created and the type of backup that was performed. If a full backup was performed, the file includes the number of indexes. For each table that was backed up, the file specifies the name, backup sequence, and the number of columns and records that are in the table.
verifies that all or selected tables from a backup file can be restored, but does not do the actual restore.
restores the backed up domain ACL (access control list) files if they do not already exist.
restores the backed up domain ACL files if they do not exist or overwrites the current files if they do exist.
restores only the domain ACL files, and nothing else.
specifies the server domain that you want to restore.
specifies the backup
filename prefix as specified in spdsbkup that you use to restore all
backup files in the directory with the name <extfile>_BK_ddmmmyyyy_hhmmss.0.0.0.spds9.
The backup files are restored in order from oldest to newest as determined
by the ddmmmyyyy_hhmmss component
of the filename.
specifies the name of the backup file that contains the tables to restore.
specifies host name of the name server. If you do not specify this option, the default value is SpdsName.
specifies to print a hash sign (#) to STDOUT for each 256K compressed block that is read from the backup file.
specifies that indexes should not be created for a full restore of a table that was backed up with index information.
specifies the user password.
specifies the domain project directory.
runs spdsrstr in quiet mode, which includes only error and warning messages in the output during a restore operation.
specifies the number of times spdsrstr retries accessing tables that are not available during a restore operation because they were in Query or Update mode. The spdsrstr utility cannot restore a table if that table is in Query or Update mode when spdsrstr accesses it. The utility pauses 5 seconds, and then retries the table if it was in Query or Update mode. The default retry count is 1.
specifies the port number of the name server. If you do not specify this option, the default port number of the name server is 5400.
specifies the SPD Server user ID of the user. Used in conjunction with the -P option.
specifies the list of tables to restore from the backup file. If you do not specify any tables, all the tables in the file are restored.
indicates the restore was successful.
indicates one or more tables could not be restored. Examine your SAS log for warning messages.
indicates a critical error caused the process to terminate early. Examine your SAS log for warning and error messages.