SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 250 / 271

Example 1: Exclusive SPD Server Full and Incremental Backups
You can use SPD Server backup and restore utilities exclusively to perform full and
incremental table backups and restores.
This example outlines the steps you use to perform a full backup of your domain once a
week, and to perform incremental backups the rest of the week. The incremental backups
will also fully back up any newly created tables.
1. On Sunday, February 3, 2008 at 23:30, run the SPD Server backup utility to do a full
backup of the domain:
spdsbkup -full -a -d test -h host -s serv -f backup
The backup creates the backup data file backup_BK_05Feb2006_233000.0.0.0.spds
and the backup table of contents file backup_TC_03Feb2008_233000 . The backup
file contains the full SPD Server backup for each table and any ACL files in the domain.
The table of contents file contains information for each table that was backed up.
2. Archive the SPD Server backup file and source in the table of contents file into a SAS
table of contents table.
3. On Monday night through Saturday night, use the SPD Server backup facility to
perform incremental backups:
spdsbkup -a -d test -h host -s serv -f backup
This statement performs incremental SPD Server backups of tables that were previously
backed up, performs a full backup of tables that were created after the previous night's
backup, and also backs up any ACL files that are in the domain.
Example 2: SPD Server Incremental/Full Backups and System Full
Backups
You can use SPD Server utilities to perform incremental backups on data sets that you have
previously archived, as well as to perform full backups on new data sets that have never
been backed up. You can also back up your SPD Server data sets using a system utility
from your native operating environment. Which one should you use? The advantage in
using system full backups is that a system utility does not parse the data set, and therefore
usually runs faster than the SPD Server utility when performing a full backup. For example,
system utilities often write directly to tape storage media. In contrast, the SPD Server utility
first writes backup data to a file on the hard drive, and then the backup file is usually backed
up to tape.
This example outlines the steps you use to perform a full system backup of the domain
"test" using operating system utilities once a week, then use SPD Server to perform a
domain back up on the remaining nights.
1. On Sunday, February 3, 2008 at 23:30, run the SPD Server list utility
spdsls -l
to
produce a listing of the tables that belong to the domain "test" in preparation for a full
backup.
spdsls -l -a <physical_path_of_domain>
Run the operating system backup utility to perform a full backup of the domain tables
and ACL files, and then archive the backup.
2. On Monday, February 4, 2008 at 23:30, run the SPD Server backup utility spdsbkup
and set the last full backup date to the previous night for the 'test' tables. Spdsbkup
then performs an incremental backup of tables that have changed since the last full
system backup, and performs a full backup of tables that were created after the last full
system backup was performed.
spdsbkup -d test -h host -s serv -t 02/04/08:23:30:00 -f backup
244
Chapter 19 • SPD Server Backup and Restore Utilities