SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 249 / 271

-v
Verify which tables in the backup file can be restored, but do not actually perform the
restore operations.
[Table ...]
The list of tables to restore from the backup file. If no tables are specified, all tables in
the file are restored.
Note: The list of tables must be the last option specified in your spdsrstr command.
Restore Return Values
When spdsrstr exits, it generates a return value. If the spdsrstr return value is 0, the utility
was successful. If the spdsrstr return value is 1, one or more data sets could not be restored.
In that case, examine your SAS log for WARNING information. If the spdsrstr return
value is 2, a critical error caused an early process termination. Examine your SAS log for
WARNING and ERROR information.
Restore User Messages
Successful Restore
If spdsrstr successfully restores a table, it writes some notes to stdout , unless the
-q
option
is specified. The notes include useful information, such as the name of the table that was
restored, the number of rows that were restored, and whether the restore that was performed
was a full restore or an incremental restore.
Warning: Table Cannot Be Restored
If spdsrstr cannot restore a table, it will print an error message stating the reason for the
failure. No tables are restored after the failure.
Failed Restore
If the spdsrstr utility detects a serious failure condition, it will halt and print an error
message that states the reason for the failure.
Restore Usage Examples
Backup and Restore Utility Example Scenario
Here are some common SPD Server backup and restore utility examples. In our example
scenario, the starting date for the backup cycle is Sunday, February 3, 2008. The weekly
schedule includes
• a full backup of the SPD Server domain "test" every Sunday at 23:30
• an incremental backup of the domain at 23:30 the rest of the week.
• Exclusive SPD Server Full and Incremental Backups
• SPD Server Incremental/Full Backups and System Full Backups
• Restoring a Single SPD Server Table
• Restoring an SPD Server Domain
Restore Usage Examples
243