Using the dump and load commands  Making routine transaction log dumps: dump transaction

Chapter 11: Developing a Backup and Recovery Plan

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.





Copyright © 2005. Sybase Inc. All rights reserved. Making routine transaction log dumps: dump transaction

View this book as PDF