unload sybase database

$ isql -U xxxx -S SASP -w 999 -Dmaster

1> sp_helpdb

 name             db_size       owner        dbid   created        status                                     
-------------- ------------- ------------ ------ -------------- --------------------------------------

ACSON           75.0 MB acsonowner     5 Feb 22, 2007   select into/bulkcopy/pllsort, trunc log on chkpt    

SAS             80.0 MB sa             4 Feb 22, 2007   select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full
audit_hist    2304.0 MB sa             6 Feb 22, 2007   select into/bulkcopy/pllsort, trunc log on chkpt              

master          93.5 MB sa             1 Jan 01, 1900   no options set
model            2.0 MB sa             3 Jan 01, 1900   no options set                                                

sybsecurity     80.0 MB batchsa    31515 Feb 23, 2007   select into/bulkcopy/pllsort
sybsystemdb      7.0 MB sa         31513 Nov 03, 1999   trunc log on chkpt                                            

sybsystemprocs 100.0 MB sa         31514 Feb 22, 2007   trunc log on chkpt                                            

tempdb         110.0 MB sa             2 Nov 27, 2008   select into/bulkcopy/pllsort,trunc log on chkpt,abort tran on log full                               

(1 row affected)

(return status = 0)

1> dump database SAS

Backup Server session id is:  130.  Use this value when executing the 'sp_volchanged' system stored procedure
after fulfilling any volume change requ
est from the Backup Server.


Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_1_2009042_1010_Mo.dmp.

Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_2_2009042_1010_Mo.dmp.

Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_3_2009042_1010_Mo.dmp.

Backup Server: 4.41.1.1: Creating new disk file /var/opt/data/DUMP/sybase/SAS_4_2009042_1010_Mo.dmp.


Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9    ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_2_2009042_1010_Mo.dmp
'

Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9    ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_1_2009042_1010_Mo.dmp'

Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9    ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_3_2009042_1010_Mo.dmp'

Backup Server: 6.28.1.1: Dumpfile name 'SAS0911708FA9    ' section number 1 mounted on disk file '/var/opt/data/DUMP/sybase/SAS_4_2009042_1010_Mo.dmp'


Backup Server: 4.58.1.1: Database SAS: 630428 kilobytes DUMPed.
Backup Server: 4.58.1.1: Database SAS: 1255406 kilobytes DUMPed.

Backup Server: 4.58.1.1: Database SAS: 1873240 kilobytes DUMPed.

[...]

Backup Server: 4.58.1.1: Database SAS: 62974550 kilobytes DUMPed.

Backup Server: 4.58.1.1: Database SAS: 63591176 kilobytes DUMPed.

Backup Server: 4.58.1.1: Database SAS: 64218620 kilobytes DUMPed.

Backup Server: 3.43.1.1: Dump phase number 1 completed.

Backup Server: 3.43.1.1: Dump phase number 2 completed.

Backup Server: 3.43.1.1: Dump phase number 3 completed.

Backup Server: 4.58.1.1: Database SAS: 64253540 kilobytes DUMPed.

Backup Server: 3.42.1.1: DUMP is complete (database SAS).

1> exit

$ ls -la SAS*

-rw-r-----   1 sybase   sybase   16449122304 Apr 27 10:27 SAS_1_2009042_1010_Mo.dmp
-rw-r-----   1 sybase   sybase   16448667648 Apr 27 10:27 SAS_2_2009042_1010_Mo.dmp

-rw-r-----   1 sybase   sybase   16449382400 Apr 27 10:27 SAS_3_2009042_1010_Mo.dmp

-rw-r-----   1 sybase   sybase   16448501760 Apr 27 10:27 SAS_4_2009042_1010_Mo.dmp

-- bei bedarf mit "scp" auf einen anderen Server kopieren. 

$ scp -B -p -q -Q SAS_[1234]_2009042_1010_Mo.dmp rmx114:/var/opt/data/DUMP/backup/sybase/