Sybase backup과 restore

backup

 isql -Usa -P -i dumpbak.sql -odumpbak.log

 

 Database dump를 위한 sql

use ebaidb1
go
dump database ebaidb1 to dump_database_dev
go
exit

 

transaction dump를 위한 sql

use ebaidb1
go
dump transaction ebaidb1 to dump_transaction_dev
go
exit

 

restore

 

database restore

 Load database ebaidb1 from dump_database_dev

 

 transaction restore

Load tran ebaidb1 from dump_transaction_dev