SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 253 / 271

Use the following steps to use PROC SPDO to execute SPD Server backup and restore
utilities:
1. Create an SPD Server LIBNAME, and specify 'special' privileges.
libname backup sasspds 'test'
host='sunny'
serv='5150'
user='admin'
passwd='admin'
ACLSPECIAL=YES;
Our example creates the LIBNAME backup for domain "test" on the host machine
'sunny'. The port number of the name server is 5150, and 'admin' is the SPD Server user
ID and password.
2. Invoke PROC SPDO for the LIBNAME.
PROC SPDO lib=backup;
3. Use PROC SPDO remote system commands to issue backup and restore statements on
the server. The following example performs a full SPD Server backup of the domain
"tstdomn" at 23:30 on February 3, 2008.
spdscmd 'spdsbkup -a -full -d tstdomn -h sunny -s 5150 -f /spdsadm/bkup/test';
The example statement creates the backup file
/spdsadm/bkup/
test_BK_03Feb2008_233000.0.0.spds
and the table of contents file
/
spdsadm/bkup/test_TC_03Feb2008_233000
on the server.
4. If a later restore operation is necessary, specify a run of the SPD Server restore utility
to restore the domain to its last full backup state.
spdscmd 'spdsrstr -aforce -d tstdomn -h sunny -s 5150 -e /spdsadm/bkup/test
Back Up and Restore Table Indexes using SPD
Server Full Backups
When you perform an SPD Server full backup of a table, by default the utility saves
information to recreate the indexes. This information is subsequently used if the table is
fully restored, to be able to recreate the indexes.
The SPD Server full backup utility does not save the index data, only the information
necessary to recreate the indexes when the table is restored. Therefore, when backing up
table indexes, the saved information requires no additional overhead and little additional
space.
If you must fully restore a table later, there are two methods available for restoring the
indexes:
1. You can allow the SPD Server restore utility to recreate the indexes when the table is
created. In this method, as each observation is added to the table, the index will be
dynamically updated.
2. Alternatively, you can use the
-n
option of the SPD Server restore utility. The
-n
option
suppresses index creation. After the table is fully restored, you can use PROC
DATASETS or PROC SQL to recreate the indexes.
Back Up and Restore Table Indexes using SPD Server Full Backups
247