Chapter 1: System Database Recovery

This chapter provides step-by-step procedures for recovering from various disaster situations involving Sybase system databases or the entire master device.

Some procedures describe how to rebuild the master database or master device. Prior to Adaptive Server version 12.5, these tasks used buildmaster. Starting with version 12.5, the buildmaster functionality has been incorporated into the dataserver (Unix) and sqlsrvr (Windows) programs. The server now allows you to create master devices and databases with 2K, 4K, 8K or 16K logical page sizes. The recovery instructions describe both the new procedure and the older pre-12.5 techniques.

WARNING! Storing the system databases sybsystemprocs, sybsecurity, and sybsyntax, and user databases on the master device is not recommended, as this greatly complicates disaster recovery.