SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador
The spdsbkup utility stores backup data in a file named file_BK_ddmmmyyyy_hhmmss.
0.0.0.spds. The suffix, added to the filename, generates a unique backup file that indicates
when the backup was performed. Because the suffix is unique, the same filename can be
used for successive backups of a domain or a table, without overwriting an existing file.
0.0.0.spds. The suffix, added to the filename, generates a unique backup file that indicates
when the backup was performed. Because the suffix is unique, the same filename can be
used for successive backups of a domain or a table, without overwriting an existing file.
Backup Data File Extensions
If the backup file exceeds the system file size limit, spdsbkup automatically extends the
file, storing the excess data in additional files. The software identifies these files with a file
extension after the date/time. (The SPD Server file extension is the "0.0.0" portion of the
filename.) While the extensions for the files will vary, the date/time will be the same on
all the files.
file, storing the excess data in additional files. The software identifies these files with a file
extension after the date/time. (The SPD Server file extension is the "0.0.0" portion of the
filename.) While the extensions for the files will vary, the date/time will be the same on
all the files.
You must have a backup file complete with filename extension before you can begin a
restore session.
restore session.
Backup Table of Contents File
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.
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.
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.
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.
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
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.;
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.;
Backup Table of Contents File
239