SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

Alternatively, you could use the 

 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.

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 

 option will cause the domain ACLs to be updated for each restore file,

resulting in the latest backup of the ACLs being restored.

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

.

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 

.

Currently, there is a limitation when using the 

 option with PROC SPDO to

restore on Windows. The 

 option fails if ACLs exist and there are active

connections to the domain that were specified using the 

 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.