| Proof of concept (Sybase ASE) |
|
|
|
| Written by repostor | |
| Tuesday, 22 December 2009 22:09 | |
1) Create a script that load test data in a database.--------- UNIX / Linux ---------# vi insert.sh
2) Run the script in a command shell--------- UNIX / Linux ---------# chmod 777 insert.sh # ./insert.sh 3) Do a full backup--------- UNIX / Linux ---------# /opt/repostor/rdp4Sybase/bin/sybasebackup -u sa -s test 4) Do a incremental backup--------- UNIX / Linux ---------# /opt/repostor/rdp4Sybase/bin/sybasebackup -u sa -s test -l 6) Avbryt (terminate "insert.bat" / "insert.sh" script7) Do a new incremental backup--------- UNIX / Linux ---------# /opt/repostor/rdp4Sybase/bin/sybasebackup -u sa -s test -l 8) Verify content in the "test" table, in the test databaseprintf "select * from test\n\go\n"|isql -U sa -P "" -D test tid2009-09-08 14:26:06 9) Drop the test databasen# printf "drop database test\ngo\n"|isql -U sa -P "" 10) Create the test database# printf "create database test on db=100 log on log=100 for load\ngo\n"|isql -U sa -P "" 11) Restore the test database from backupRun kommandot: --------- UNIX / Linux ---------# /opt/repostor/rdp4Sybase/bin/sybaserestore -u sa -s test -v -l -t YYYY-MM-DD.HH:MM:SS Where: YYYY-MM-DD.HH:MM:SS is any date / time from the list above Eg;; # sybaserestore -u sa -s test -v -l -t 2009-11-25.19:11:27 12) online database# printf "online database test\ngo\n"|isql -U sa -P "" 13) Verify content of the test table in the test database# printf "select * from test\ngo\n"|isql -U sa -P "" -D test |



