When you perform an
SPD Server full backup of a table, by default the utility saves information
to re-create the indexes. This information is subsequently used to
re-create the indexes if the table is fully restored.
The SPD Server full
backup utility does not save the index data. The utility saves only
the information necessary to re-create the indexes when the table
is restored. Therefore, when you back up table indexes, the information
that is saved does not require additional overhead or a lot of additional
space.
If you must fully restore
a table later, you can use one of the following two methods to restore
the indexes:
-
The SPD Server restore utility
can re-create the indexes when the table is created. In this method,
the index is updated dynamically as each observation is added to the
table.
-
Use the -n option on the SPD Server
restore utility. The -n option suppresses the creation of an index.
After the table is fully restored, you can use PROC DATASETS or PROC
SQL to re-create the indexes.