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.