SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

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 

 and the table of contents file 

 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

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 

 option of the SPD Server restore utility. The 

 option

suppresses index creation. After the table is fully restored, you can use PROC
DATASETS or PROC SQL to recreate the indexes.