Specifying additional dump devices: the stripe on clause  Loading from multiple devices

Chapter 12: Backing Up and Restoring User Databases

Dumping to multiple devices

The Backup Server divides the database into approximately equal portions and sends each portion to a different device. Dumps are made concurrently on all devices, reducing the time required to dump an individual database or transaction log. Because each tape stores only a portion of the database, it is less likely that a new tape will have to be mounted on a particular device.

WARNING! Do not dump the master database to multiple tape devices. When loading the master database from tape or other removable media, you cannot change volumes unless you have another Adaptive Server that can respond to volume change messages.





Copyright © 2005. Sybase Inc. All rights reserved. Loading from multiple devices

View this book as PDF