Making routine database dumps: dump database

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.