You are here

load sybase database

bash-2.03$ isql -S SASB -U xxxxx -w 999 -Dmaster
1> sp_helpdb
2> go 
 name                     db_size       owner                    dbid   created        status                                 
                                                              
 ------------------------ ------------- ------------ ------ -------------- ----------------------------------------
ACSON                          75.0 MB acsonowner     6 Mar 14, 2007   select into/bulkcopy/pllsort, trunc log on chkpt                                                      
SAS                         73680.0 MB sa             4 Mar 14, 2007   select into/bulkcopy/pllsort, trunc log on chkpt, don't recover, abort tran on log full, offline      
audit_hist                   2304.0 MB sa             7 Mar 14, 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  3151  5 Mar 14, 2007   select into/bulkcopy/pllsort          
sybsystemdb                     7.0 MB sa       3151  3 Nov 03, 1999   trunc log on chkpt                     
sybsystemprocs                100.0 MB sa       3151  4 Mar 14, 2007   trunc log on chkpt                     
tempdb                       8110.0 MB sa             2 Nov 26, 2008   select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full                              

(1 row affected)
(return status = 0)

 

1> load database SAS
2> from "/var/opt/data/DUMP/backup/sybase/SAS_1_20090413_2030_Mon.dmp"
3> stripe on "/var/opt/data/DUMP/backup/sybase/SAS_2_20090413_2030_Mon.dmp"
4> stripe on "/var/opt/data/DUMP/backup/sybase/SAS_3_20090413_2030_Mon.dmp"
5> stripe on "/var/opt/data/DUMP/backup/sybase/SAS_4_20090413_2030_Mon.dmp"
6> go  

Backup Server session id is:  139.Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server. Backup Server: 6.28.1.1: Dumpfile name 'SAS0910312055    ' section number 1 mounted on disk file '/var/opt/data/DUMP/backup/syb ase/SAS_3_20090413_2030_Mon.dmp' Backup Server: 6.28.1.1: Dumpfile name 'SAS0910312055    ' section number 1 mounted on disk file '/var/opt/data/DUMP/backup/syb ase/SAS_4_20090413_2030_Mon.dmp' Backup Server: 6.28.1.1: Dumpfile name 'SAS0910312055    ' section number 1 mounted on disk file '/var/opt/data/DUMP/backup/syb ase/SAS_2_20090413_2030_Mon.dmp' Backup Server: 6.28.1.1: Dumpfile name 'SAS0910312055    ' section number 1 mounted on disk file '/var/opt/data/DUMP/backup/syb ase/SAS_1_20090413_2030_Mon.dmp' Backup Server: 4.58.1.1: Database SAS: 754512 kilobytes LOADed. Backup Server: 4.58.1.1: Database SAS: 1514706 kilobytes LOADed.
[...]
Backup Server: 4.58.1.1: Database SAS: 75456244 kilobytes LOADed. Backup Server: 4.58.1.1: Database SAS: 75460560 kilobytes LOADed. Backup Server: 3.42.1.1: LOAD is complete (database SAS).
Redo pass of recovery has processed 1 committed and 0 aborted transactions.
Use the ONLINE DATABASE command to bring this database online;
SQL Server will not bring it online automatically.

 

1> sp_helpdb
2> go
name                     db_size       owner                    dbid   created        status                                  
                                                               
 ------------------------ ------------- ------------ ------ -------------- ----------------------------------------
ACSON                          75.0 MB acsonowner     6 Mar 14, 2007   select into/bulkcopy/pllsort, trunc log on chkpt                                                       
SAS                         73680.0 MB sa             4 Mar 14, 2007   select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full                               
audit_hist                   2304.0 MB sa             7 Mar 14, 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  3151  5 Mar 14, 2007   select into/bulkcopy/pllsort           
sybsystemdb                     7.0 MB sa       3151  3 Nov 03, 1999   trunc log on chkpt                      
sybsystemprocs                100.0 MB sa       3151  4 Mar 14, 2007   trunc log on chkpt                      
tempdb                       8110.0 MB sa             2 Nov 26, 2008   select into/bulkcopy/pllsort, trunc log on chkpt, abort tran on log full                               

(1 row affected)
(return status = 0)