SAS Safety Scalable Performance Data Server 4.5 User Manual

•

When an incremental backup is restored, only the incremental changes to the
observations are applied.

•

When a full backup is restored, the table is created with the attribute settings that existed
when the full backup was performed, and then all of the rows are added.

Before you can use the spdsrstr utility to restore a table, the following must be true:

•

The table to be restored must be identical to the table that was backed up. That is, the
name and create date must match the name and create date of the backed up table.

•

Incremental table restores must be performed in the same order as the incremental
backups that were performed.

•

The table must not have been modified between the incremental restore dates, assuring
that the table is returned to the exact state at time of backup.

•

The backup file (with any file extension) must be available.

If a table does not meet all of the criteria, spdsrstr prints a warning message to stdout, and
does not restore the table. If spdsrstr is restoring multiple tables, it will restore only the
tables that meet the restore criteria.

spdsrstr -d <dom> -h <host> {-f <fullfile> | -e <extfile>} [-hash]
 [-r <count>] [-a | -aforce] [-aonly] [-n] [-q] [-s <serv>]
 [-u <user>] [-p <passwrd>] [-proj <dir>] [table ...]

spdsrstr -v -d <dom> -h <host> {-f <fullfile> | -e <extfile>}
 [-s <serv>] [-u <user>] [-p <passwrd>] [-proj <dir>] [table ...]

spdsrstr -t {-f <fullfile> | -e <extfile>} [table...]

spdsrstr -help

spdsrstr

Restores all or selected tables from a backup file.

spdsrstr -t

Prints a table of contents for a backup file indicating when the backup file was created,
and whether it is a full backup, and if so, the number of indexes. Further, it lists for
each backed up table, the name, backup sequence, and the number of columns and
records that are contained in the table.

spdsrstr -v

Verifies all or selected tables from a backup file can be restored, but does not do the
actual restore.

-a

restore the backed up domain ACL (Access Control List) files if they do not already
exist.