These procedures assume that the rest of the master device
and the sybsystemprocs database are intact.
If your master device has a non-default sort order, go to “Valid Dump with Non-Default Sort Order”.
Rebuild the master database without initializing the master device. Refer to “How to Rebuild master Database and Leave Master Device Intact”.
After rebuilding master, you may need to alter the master database on the master device to ensure that the lstart, vstart, and size values of master match up with those on the dump. Otherwise, you may see corruption following the load of master in a subsequent step.
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.
Ensure that the Adaptive Server has the correct name for the Backup Server in the sysservers table. Refer to “How to Set A Default Backup Server Manually in Adaptive Server” for instructions.
Load the master database from backup using the load database command to specify the physical device or file name to reference. For example:
1> load database master from "device_name" 2> go
Adaptive Server automatically shuts down after the load is complete.
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.
Restore system catalog information for the master database if changes were made to it since the last dump. Refer to “How to Restore System Table Information in master Database”.
Dump the master database.
Shut down Adaptive Server.
Start Adaptive Server in multiuser mode. Refer to “Returning Adaptive Server to Multiuser Mode”.
