SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 242 / 271

Backup Usage
spdsbkup -d <dom> -f <file> -h <host> [-hash] [-s <serv>] [-u <user>]
[-fibfact <n>] [-p <passwd>][-t <mm/dd/yy:hh:mm:ss>] [-r <count>]
[-a | -aonly] [-n] [-q] [-v] [-nv6warn] [-proj <dir>] [Table ...]
spdsbkup -inc -d <dom> -f <file> -h <host> [-hash] [-s <serv>] [-u <user>]
[-fibfact <n>] [-p <passwd>][-t <mm/dd/yy:hh:mm:ss>] [-r <count>]
[-a | -aonly] [-q] [-v] [-nv6warn] [-proj <dir>] [Table ...]
spdsbkup -full -d <dom> -f <file> -h <host> [-hash] [-s <serv>][-u <user>]
[-fibfact <n>] [-p <passwd>] [-r <count>] [-a | -aonly] [-n] [-q]
[-v] [-nv6warn] [-proj <dir>] [Table ...]
spdsbkup
Performs an incremental or full backup of SPD Server tables.
• If a table DOES NOT have a pre-existing full backup, it performs a full backup of
the table and sets the last full backup date.
• If the table DOES have a pre-existing full backup, it performs an incremental
backup. The incremental backup uses the latest full or incremental backup date as
the beginning point for the incremental content change for the table.
spdsbkup -inc
Performs only incremental backups of SPD Server tables.
• If a full backup (required for an incremental) is unavailable, it prints a warning
message and the table is not backed up.
• If a full backup is available, it performs an incremental backup of the table using
the later of the two dates: the last full backup or the last SPD Server incremental
backup for the table.
• Attribute changes to the table are not backed up in an incremental backup. Only the
incremental changes for the rows since the last backup are backed up.
Note: When an incremental backup is restored, only the incremental changes to
the rows are applied. Any indexes defined for the table will be updated
accordingly.
spdsbkup -full
Performs only full backups of SPD Server tables. All of the table observations and
attributes (indexes, definitions, partition size, compression and sorted) are backed up.
After each full table backup, it resets the last full backup date for the table. See the -n
option for dependencies.
Note: When a full backup is restored, the table is created with those attributes and then
all of the rows are added.
Backup Options
-a
Include the domain ACL files in the backup.
236
Chapter 19 • SPD Server Backup and Restore Utilities