Sybase 12.4.2 User Manual

Page 405

Advertising
background image

CHAPTER 11 Backup and Data Recovery

385

Backup file names for
backup to disk

BACKUP

always assigns file names to disk backup files by appending a suffix

to the archive_device name you specify. The suffix consists of “.” followed by
a number that increases by one for each new file. For example, if you specify
/iqback/mondayinc as the archive_device, the backup files are
/iqback/mondayinc.1, /iqback/mondayinc.2, and so on. This convention allows
you to store as large a backup as you need, while allowing you control over the
file size; see the

SIZE

option for details. Your file system must support long file

names to accommodate this convention.

You must make sure that the directory names you specify for the
archive_device exist.

BACKUP

does not create missing directories. If you try to

start a backup in a directory that does not exist, the backup fails.

You should avoid using relative pathnames to specify the location of disk files.

BACKUP

interprets the pathname as relative to the location where the server

was started, which you may not be able to identify with certainty when you do
a backup. Also, if there is data in other directories along the path, you may not
have enough room for the backup.

Positioning tape
devices

BACKUP

does not position tapes for you. You must position the tape

appropriately before starting your backup, and be sure that you do not
overwrite any of the backup if you use a rewinding tape device. For these
reasons, Sybase recommends you use a non-rewinding tape device. See the
operating system documentation for your platform for appropriate naming
conventions.

Specifying tape
devices on UNIX

Here are examples of how you specify non-rewinding tape devices on UNIX
platforms:

On Sun Solaris platforms, insert the letter n for “no rewind” after the
device name, for example, '/dev/rmt/0n'.

On IBM AIX platforms, use a decimal point followed by a number that
specifies the appropriate compression setting with rewind setting, for
example, '/dev/rmt0.1'.

On HP-UX platforms, use '0m' to specify the default tape mechanism and
'n' for “no rewind,” for example, '/dev/rmt/0mn'.

On DEC UNIX platforms, put an n in front of the device name, for
example, '/dev/nrmt0h'.

Warning!

If you misspell a tape device name and write a name that is not a

valid tape device on your system,

BACKUP

assumes it is a disk file.

Advertising