psDumpDatabase

Description

     This program dumps a database.  You can dump the database
to disk or to tape.  You can dump the database to any Sybase
Backup Server so long as the ASE Server knows about the Backup
Server.  You can dump the database in one or more stripes.
You can tell psDumpDatabase to generate dump file names for you.
If you specify generated dump file names, the file names will embed
a time signature in Universal Time.
     psDumpDatabase exits with a 0 if your dump completed
successfully.  If Sybase was unable to dump the database, then psDumpDatabase
exits with a non-zero return code.  Whether or not the dump was successful,
psDumpDatabase writes text messages to your messages log file.
     If you wish to retrieve the text message associated with the non-zero
exit code, then run psShowMessage.

Syntax

psDumpDatabase
-Sserver -Uusername -Ppassword -Ddatabase
-Bbackup_server_name -Xdump_db_directory -Ldump_db_file
-Rlist_of_stripes_file
-Fmessage_log_file -Mmax_msg_log_file_size
-Ttime_out
-Ctape_capacity_GB
-Eemail_address_when_error
-Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database

-B

Backup Server Name [SYB_BACKUP]

-X

Database Dump File Directory

-L

Database Dump File Name

-R

Input Text File Containing a List of Stripe Files

-T

Time out in seconds. [18000 seconds]

-C

The Tape's Capacity in Gigabytes

-F

Messages Log File. [standard output]

-M

Maximum Size of Log File [1,000,000 bytes]

-E

E-mail address to send error messages when there are errors

-O

Options

i

Initialize tape (write over previous contents)

r

Rewind and unload tape when done

l

Log full informational messages

a

Do not log abbreviated informational messages

DSQUERY

When -S is not specified.

SYB_USER

When -U is not specified.

SYB_PASS

When -P is not specified.

SYB_DATABASE

When -D is not specified.

PS_SYSMSG_FILE

Name of the tool's messages file.

Notes

-R      If you specify -R, the input file containing the list of
        stripes, your text file can have 2 columns like:
        directory_name_1   stripe_file_name_1
        directory_name_2   stripe_file_name_2
        .                  .
        .                  .
        .                  .
        directory_name_n   stripe_file_name_n
        Or your text file can have just 1 column:
        directory_name_1
        directory_name_2
        .
        .
        .
        directory_name_n
        If you specify just a single column of directory names, then
        the stripe file names are generated.  The generated names look like:
                  SERVER_DB_yyyymmddhhmmssUT.db_dump_N
        where SERVER is the SQL Server name, DB is the database name,
        and N is the stripe number.
----------------------------------------------------------------