$ isql -U xxxx -S SASP -w 999 -Dmaster
1> sp_helpdb
2> go
name db_size owner dbid created status
-------------- ------------- ------------ ------ -------------- -------------------------------------- ACSON 75.0 MB acsonowner5 Feb 22 , 2007 select into/bulkcopy/pllsort, trunc log on chkpt SAS 80.0 MB sa4 Feb 22 , 2007 select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full audit_hist 2304.0 MB sa6 Feb 22 , 2007 select into/bulkcopy/pllsort, trunc log on chkpt master 93.5 MB sa1 Jan 01 , 1900 no options set
model 2.0 MB sa3 Jan 01 , 1900 no options set sybsecurity 80.0 MB batchsa 31515Feb 23, 2007 select into/bulkcopy/pllsort
sybsystemdb 7.0 MB sa 31513Nov 03, 1999 trunc log on chkpt sybsystemprocs 100.0 MB sa 31514Feb 22, 2007 trunc log on chkpt tempdb 110.0 MB sa2 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
2> to "/var/opt/data/DUMP/sybase/SAS_1_2009042_1010_Mo.dmp"
3> stripe on "/var/opt/data/DUMP/sybase/SAS_2_2009042_1010_Mo.dmp"
4> stripe on "/var/opt/data/DUMP/sybase/SAS_3_2009042_1010_Mo.dmp"
5> stripe on "/var/opt/data/DUMP/sybase/SAS_4_2009042_1010_Mo.dmp"
6> go
Backup Server session id is: 130. Use this value when executing the 'sp_volchanged' system stored procedure
after fulfilling any volume change request 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 16449122304Apr 27 10 :27 SAS_1_2009042_1010_Mo.dmp -rw-r----- 1 sybase sybase 16448667648Apr 27 10 :27 SAS_2_2009042_1010_Mo.dmp -rw-r----- 1 sybase sybase 16449382400Apr 27 10 :27 SAS_3_2009042_1010_Mo.dmp -rw-r----- 1 sybase sybase 16448501760Apr 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/