Making routine transaction log dumps: dump transaction  Restoring the entire database: load database

Chapter 11: Developing a Backup and Recovery Plan

Copying the log after device failure: dump tran with no_truncate

If your data device fails and the database is inaccessible, use the with no_truncate option of dump transaction to get a current copy of the log. This option does not truncate the log. You can use it only if the transaction log is on a separate segment and the master database is accessible.





Copyright © 2005. Sybase Inc. All rights reserved. Restoring the entire database: load database

View this book as PDF