After performing each SPD Server backup, you should append the resulting table of
contents file to the SAS table of contents backup file. This is an important step because it
saves the backup history, and assists later when restoring tables.
For example, if you want to determine which backup files you need to restore a specific
table, using a last full backup with a known date, you could create the following SQL query:
select bk_file from foo.bkup_toc
where table = "dset"
and datepart(lastfull) >= 'ddmmmyyyy'd;
Backup User Messages
Confirm Your Backup Job Status
Three basic types of SPD Server spdsbkup backup user messages can appear in your SAS
log:
• Successful Backup
• Warning: Table Cannot Be Backed Up
• Failed Backup: Error and Program Aborts.
Successful Backup
If spdsbkup successfully backs up a table, it writes some notes to stdout, unless the quiet
-q option is specified. The notes include useful summary information, such as the name
of the table that was backed up, the number of observations that were backed up, and
whether the back up that was performed was a full backup or an incremental backup.
Warning: Table Cannot Be Backed Up
If spdsbkup cannot back up a table, it will print a warning message that states why the
table could not be backed up.
Failed Backup
If the spdsbkup utility detects a serious failure condition, it will halt and print an error
message that states the reason for the failure.
Spdsrstr - the SPD Server Table Restore Utility
Restore Description
Spdsrstr is a restore utility that uses a backup file to restore a specified set of SPD Server
tables. Tables must meet restore requirements or the spdsrstr utility bypasses them. The
spdsrstr utility can also provide a list of the tables in the backup file that are eligible for
restoration.
240 Chapter 19 • SPD Server Backup and Restore Utilities
