SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 252 / 271

Alternatively, you could use the
-e
option of spdsrstr and restore all of the files with
one single command:
spdsrstr -d test -h hostname -s serv -e backup results
Note: When you restore a single table, you do not need to restore the ACL files, because
they were not deleted.
Example 4: Restoring an SPD Server Domain
Use the following steps to restore an SPD Server domain named "test" that was lost due to
a system media failure that occurred on Friday, February 15, 2008.
1. If the domain was backed up fully using the system backup utility, use the system restore
utility to restore domain "test" to its state at the last full backup date of February 10,
2008. If the domain was backed up fully using the SPD Server utility, then skip this
step.
2. Use SAS to run a query on the backup table of contents table bkup_toc .
select bk_file from foo.bkup_toc
where domain = "test"
and dttime >= '10FEB2008:23:30:00'd;
The query results identify which SPD Server backup files are required to restore the
domain.
3. Restore the archived SPD Server backup files required to restore the domain.
4. Use the SPD Server restore utility to restore domain "test":
spdsrstr -aforce -d test -h host -s serv -e backup
The
-aforce
option will cause the domain ACLs to be updated for each restore file,
resulting in the latest backup of the ACLs being restored.
Using PROC SPDO to Back Up and Restore SPD
Server Tables
You can use the SAS PROC SPDO spdscmd to run the SPD Server backup and restore
utilities. There is one constraint: you must submit the command using an SPD Server
LIBNAME that has 'special' privileges. Backup and restore utilities require privileged
access. To grant 'special', privileges, you must specify the LIBNAME option
ACLSPECIAL=YES
.
When you execute commands using the PROC SPDO spdscmd , the current working
directory is the root directory of SPD Server. Output messages from the commands are
echoed to the SAS log. In the next example, the SPD Server incremental backup and restore
utilities reside in the SPD Server directory. The incremental backup and restore files are
saved in the server directory
/spdsadm/bkup
.
Currently, there is a limitation when using the
-aforce
option with PROC SPDO to
restore on Windows. The
-aforce
option fails if ACLs exist and there are active
connections to the domain that were specified using the
-d
option during the restore.
ACLSPECIAL= connections to a libref must specify a domain that is separate from the
domain where you are attempting to restore the ACLs (if the ACLs currently exist). Making
ACLSPECIAL= libref connections that specify the domain where you are attempting to
restore the ACLs will cause the ACL restore operation to fail.
246
Chapter 19 • SPD Server Backup and Restore Utilities