Moving databases from one Adaptive Server to another  Using the Backup Server for backup and recovery

Chapter 11: Developing a Backup and Recovery Plan

Designating responsibility for backups

Many organizations have an operator who performs all backup and recovery operations. Only a System Administrator, a Database Owner, or an operator can execute the dump and load commands. The Database Owner can dump only his or her own database. The operator and System Administrator can dump and load any database.

Any user can execute sp_volchanged to notify the Backup Server when a tape volume is changed.





Copyright © 2005. Sybase Inc. All rights reserved. Using the Backup Server for backup and recovery

View this book as PDF