Unix Backup and Recovery

Chapter 16. Sybase Backup & Recovery

Sybase has provided two utilities, dump and bcp, to facilitate the backup and recovery processes. But like Informix and Oracle, these utilities provide only a basic backup ability. At this point in time, using these utilities, it takes more than just running one simple command to make sure the data server can be restored from any calamity. Because running the various commands by hand could lead to errors (and lack of sleep for the operators), environments without a commercial utility must use backup scripts of some kind to automate the process and provide consistency. This chapter provides a solid foundation in Sybase backup and recovery techniques, so in case your server suffers an unexpected problem, the data server can be fully restored.

Tip

This chapter was written by Bryn Smith, a senior consultant with Collective Technologies. Bryn started his career in computers back in sixth grade because of the encouragement and dedication of an exceptional teacher and friend, Dorothy Edwards at North Cow Creek School. Thank you Mrs. E! Bryn has come a long way since then, is now experienced at both system and database administration, and can be reached at [e-mail].

Sybase Architecture

As in the Oracle and Informix chapters, it is important to understand the design of the database that is being backed up. Therefore, this chapter starts with a discussion of Sybase architecture. This is similar to the information provided in Chapter 13, but contains ...