SPD Server Restore Utility (spdsrstr)

Restore Requirements
Usage Overview

Restore Requirements

You must meet the following requirements before you can use the spdsrstr utility to restore a table:
  • The client that performs the restore must have access to the server domain.
  • The table to be restored must be identical to the table that was backed up. The name and creation date of the table to be restored must match the name and creation date of the backed up table.
  • You must perform incremental table restores in the same order as the incremental backups were performed.
  • The table must not have been modified between the incremental restore dates to ensure that the table is returned to the exact state at time of backup.
  • The backup file (regardless of its file extension type) 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 restores only the tables that meet the restore criteria.

Usage Overview

The spdsrstr command can be used to validate SPD Server backup files in advance of performing a restore. It can also be used to create a backup file table of contents in addition to restoring files from a backup.
When validating backup files or creating a backup file table of contents, you need to provide only the source backup files as input. There is no need to connect to SPD Server. Use the -f or -e option to identify the backup files.
When performing a restore, specify options to connect to a server domain in addition to the backup files. To restore (or validate the restore) of a single table or specified tables, include the table option.
When performing a restore, spdsrstr re-creates indexes by default. Specify the -n option if you want to suppress index creation, and re-create the indexes with PROC DATASETS or PROC SQL after the table is fully restored instead.
Domain ACL files are not restored unless you specify the -a or -aforce option. Specify -aonly to restore only the domain ACL files, and nothing else.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017