The dump database command makes a copy of the entire database, including both the data and the transaction log.
dump database does not truncate the log.
dump database allows dynamic dumps. Users can continue to make
changes to the database while the dump takes place.
This makes it convenient to back up databases on a regular basis.
dump database executes in three phases.
A progress message informs you when each phase completes.
When the dump is finished, it reflects all changes that were made during its execution,
except for those initiated during phase 3."
Phase 1
* Phase 1 is the DBPAGES phase
* The Backup Server scans and dumps all the allocated pages
(both data and log pages) for the given database, without checking to see
whether any of the pages were updated while this phase is going on.
Phase 2
* Phase 2 is the FLUSHPAGES phase:
* All the data pages that were modified during but not logged
in phase 1 are dumped.
* The dump instant is the end of this phase. Recovery restores
the database to the state after phase 2.
Phase 3
* Phase 3 is the SCANLOGPAGES phase:
* The log pages are dumped again to capture up-to-the-minute
changes.
* dump transaction has only one phase: the SCANLOGPAGES phase.
Check the ASE backup server error log for more info
sybase@<hostname>:~/ASE-16_0/install> pwd
/sybase/<SID>/ASE-16_0/install
sybase@hostname:~/ASE-16_0/install> ls -lrt
-rwx------ 1 sybase sapsys 743 Oct 16 2019 RUN_<SID>
-rwx------ 1 sybase sapsys 508 Oct 16 2019 RUN_<SID>_BS
-rw-r----- 1 sybase sapsys
656944 Jul 7 17:53
<SID>.log
-rw-r----- 1 sybase sapsys
3693831 Jul 8 02:00
<SID>_JSAGENT.log
-rw-r----- 1 sybase sapsys 27009744 Jul 8 02:55 <SID>_BS.log
sybase@hostname:~/ASE-16_0/install> cat <SID>_BS.log | grep "phase"
