These procedures assume that the rest of the master
device is intact. If this is not the case, see the following section “Master Device Is Lost and Valid Dump Exists”.
Rebuild the master database without initializing the master device. Refer to “How to Rebuild master Database and Leave Master Device Intact”.
With Adaptive Server still down, manually reestablish the number of devices configuration parameter if necessary. Refer to “How to Alter the number of devices Parameter Manually”.
Start Adaptive Server in single-user mode. Refer to “How to Start Adaptive Server in Single-User Mode”.
In Adaptive Server version 12.0.x and later, be sure
to start the server with trace flag 3608 in single-user mode. Starting
the server with trace flag 3608 prevents sybsystemdb creation
at start-up time, avoiding the potential for overwriting any user
databases that may have existed on the master device.
Restore the system tables information contained in the master database. This information describes all Sybase devices and user databases. If you have bcp files of the system tables, refer to “Manually Rebuilding Adaptive Server with bcp”; otherwise refer to “Restoring Device and Database Information in the System Catalog”.
Use sp_addserver to add a SYB_BACKUP entry to the sysservers table:
1> sp_addserver "SYB_BACKUP" null, 2> <correct_backup_server_name> 3> go
Dump the master database.
Shut down Adaptive Server.
Start Adaptive Server in multiuser mode. Refer to “Returning Adaptive Server to Multiuser Mode”.
