Dumping a database after creating an index  Dumping a database when the log has been truncated

Chapter 11: Developing a Backup and Recovery Plan

Dumping a database after unlogged operations

Adaptive Server writes the data for the following commands directly to disk, adding no entries (or, in the case of bcp, minimal entries) in the transaction log:

You cannot recover any changes made to the database after issuing one of these commands. To ensure that these commands are recoverable, issue a dump database command immediately before executing any of these commands.





Copyright © 2005. Sybase Inc. All rights reserved. Dumping a database when the log has been truncated

View this book as PDF