Saving scripts and system tables  Avoiding volume changes and recovery

Chapter 11: Developing a Backup and Recovery Plan

Truncating the master database transaction log

Since the master database transaction log is on the same database devices as the data, you cannot back up its transaction log separately. You cannot move the log of the master database. You must always use dump database to back up the master database. Use dump transaction with the truncate_only option periodically (for instance, after each database dump) to purge the transaction log of the master database.





Copyright © 2005. Sybase Inc. All rights reserved. Avoiding volume changes and recovery

View this book as PDF