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.

Ensuring Recoverability

Finding the Appropriate Recovery Scenario

master Database Is Corrupt and Adaptive Server Does Not Start

Valid Dump of the master Database Exists

Valid Dump of the master Database Does Not Exist

master Database Is Corrupt and Adaptive Server Starts

Valid Dump of the master Database Exists

Valid Dump of the master Database Does Not Exist

Master Device Is Lost and Valid Dump Exists

Valid Dump with Default Sort Order

Valid Dump with Non-Default Sort Order

Master Device Is Lost and Valid Dump Does Not Exist

The model Database Is Lost or Corrupted

ASE 12.5.x and Later

ASE 12.0.x and Earlier

Non-Master Device Containing Pieces of tempdb Is Lost

Master Device Is Going Bad

Adaptive Server Does Not Start After Altering Configuration

Manually Rebuilding Adaptive Server with bcp

Checklist

Considerations

Steps for Rebuilding Adaptive Server

If You Cannot Use bcp or a Dump


	Expand Search