A damaged master database can be caused by a media failure in the area on which master is stored, or by internal corruption in the database. Your master database is damaged if:
Adaptive Server cannot start.
There are frequent or debilitating segmentation faults or input/output errors.
dbcc reports damage during a regular check of your databases.
This section describes how to recover the master database and to rebuild the master device. It assumes:
The master database is corrupt, or the master device is damaged.
You have up-to-date printouts of the system tables, listed in Chapter 2, “System and Optional Databases,” in the System Administration Guide: Volume 1.
The master device contains only the master database, tempdb, model, and sybsystemdb.
You have an up-to-date backup of the master database, and you have not initialized any devices or created or altered any databases since last dumping master.
Your server uses the default sort order.
The Error Message and Troubleshooting Guide provides more complete coverage of recovery scenarios.