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:
-
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.
-
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.