Backup Requirements
Client Access to an SPD Server Domain
The client that performs the backup does not have to execute on the same machine as the
SPD Server. However, the client must be able to access the physical path of the SPD Server
domain that is being backed up. Access by the client to the physical path of the domain can
be direct or through a network connection.
LIBNAME Created with BACKUP= Option
Before a table is eligible for backup, you must create the SPD Server LIBNAME domain
using the
BACKUP=YES
option in the parameter file. Here are two example LIBNAME
entries from a data's server's libname parameter file, libnames.parm, to explain how
domains are processed with and without the
BACKUP=
option:
Example Libnames.parm Statements
No Backup Statement and Can Backup Statement Examples
libname=nobackup pathname=/usr/foo/test;
libname=canbackup pathname=/usr/foo/test BACKUP=YES;
The entry for the LIBNAME domain called
nobackup
creates tables in the directory
/
usr/foo/test
, but no
BACKUP=
option is specified. For this reason, tables created
through this domain definition are ineligible for backup. In contrast, the entry for the
LIBNAME domain
canbackup
, which also creates tables in the directory
/usr/foo/
test
, has the
BACKUP=YES
option. As a consequence, tables created through this domain
are eligible for backup.
When
spdsbkup
performs a backup, it checks every table in
/usr/foo/test
. However,
based on our example parameter file entries,
spdsbkup
backs up only the eligible tables
in
canbackup
. On the client connections created using pass-through or LIBNAME, the
BACKUP=NO
LIBNAME option can be used to override. Tables that are created when either
of these is in effect will be able to be backed up.
Incremental Backups Requires a Prior Full Backup
Before you can do an incremental backup of an SPD Server table, you must do a full backup
of the table. You have two alternatives for the full backup:
•
Use the system's full backup utility, and then inform
spdsbkup
of the system's last full
backup date.
•
Use
spdsbkup
to perform a full backup, if none has been done before.
After a full backup has been performed for an SPD Server table, you can then proceed with
an incremental backup strategy. The first incremental backup saves all table changes that
were performed after the last full backup date. Each successive incremental backup saves
the changes that were made after the previous incremental backup.
Example Libnames.parm Statements
235
Summary of Contents for Scalable Performance Data Server 4.5
Page 1: ...SAS Scalable Performance Data Server 4 5 Administrator s Guide...
Page 7: ...Part 1 Product Notes Chapter 1 SPD Server 4 5 Product Notes 3 1...
Page 8: ...2...
Page 12: ...6...
Page 63: ...Part 3 Migration Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility 59 57...
Page 64: ...58...
Page 70: ...64 Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility...
Page 72: ...66...
Page 76: ...70 Chapter 6 Using the SPD Server Name Server to Manage Resources...
Page 94: ...88 Chapter 7 Administering and Configuring SPD Server Using the SAS Management Console...
Page 98: ...92 Chapter 8 SPD Server SQL Query Rewrite Facility...
Page 116: ...110 Chapter 10 Configuring Disk Storage for SPD Server...
Page 128: ...122 Chapter 11 Setting Up SPD Server Parameter Files...
Page 154: ...148...
Page 198: ...192 Chapter 14 ACL Security Overview...
Page 212: ...206 Chapter 15 Managing SPD Server Passwords Users and Table ACLs...
Page 214: ...208...
Page 224: ...218 Chapter 16 SPD Server Operator Interface Procedure PROC SPDO...
Page 236: ...230 Chapter 18 SPD Server Table List Utility Spdsls...
Page 256: ...250 Chapter 19 SPD Server Backup and Restore Utilities...
Page 264: ...258 Chapter 20 SPD Server Directory Cleanup Utility...
Page 270: ......