In addition
to the backup file,
spdsbkup creates a table
of contents file using the name
file_TC_ddmmmyyyy_hhmmss. The
TC in the filename identifies it as
a table of contents file. If the table of contents file is created
in the same SPD Server operation, the timestamp for the backup file
and the table of contents file are identical. The table of contents
file does not have an SPD Server file extension. Unlike the backup
file, the table of contents file is a normal system file and cannot
be 'extended'. The table of contents file size is constrained only
by the native operating system's file size limit.
The table
of contents file contains the following information for each backed
up table:
-
Columns 1 - 32 contain the table
name or ACL name if it is a domain ACL file.
-
Columns 33 - 232 contain the backup
filename.
-
Columns 233 - 250 contain the last
full backup date, using SAS datetime18. format.
-
Columns 251 - 258 contain the incremental
backup sequence number since the last full backup. For example, a
value of 2 indicates that this is the second incremental backup since
the last full backup.
-
Columns 259 - 268 contain the number
of rows that were backed up.
-
Column 269 contains F for a full
SPD Server backup, or I for an incremental backup.
-
Columns 270 - 277 contain the number
of indexes that were backed up during a full SPD Server backup. This
field contains a 0 if an incremental backup is being performed.
-
Column 278 is a Boolean ACL file
indicator. Column 278 contains a T if a domain ACL file is being backed
up, and an F if a table is being backed up. If the ACL file indicator
is set to T, columns 1-32 are configured for ACL names.
The table
of contents file is formatted so that it can be used as a table of
contents for a SAS backup file. The SAS format for the table of contents
file is
format lastfull datetime18.;
input @1 table $32. @33 bk_file $200.
@233 lastfull datetime18. @251 inc_seq 8.
@259 rows 10. @269 bk_type $1.
@270 num_idx 8.,
@278 acls $1.;
After
performing each SPD Server backup, you should append the resulting
table of contents file to the SAS table of contents backup file. This
is an important step because it saves the backup history, and assists
later when restoring tables.
For example,
if you want to determine which backup files you need to restore a
specific table, using a last full backup with a known date, you could
create the following SQL query:
select bk_file from foo.bkup_toc
where table = "dset"
and datepart(lastfull) >= 'ddmmmyyyy'd;