Dumping a database when the log has been truncated  Dumping master after each change

Chapter 11: Developing a Backup and Recovery Plan

Scheduling backups of master

Back up the master database regularly and frequently.

Backups of the master database are used as part of the recovery procedure in case of a failure that affects the master database. If you do not have a current backup of master, you may have to reconstruct vital system tables at a time when you are under pressure to get your databases up and running again.





Copyright © 2005. Sybase Inc. All rights reserved. Dumping master after each change

View this book as PDF