Rebuild the lost master device. Refer to “How to Build a New Master Device” for instructions.
Start Adaptive Server in single-user mode. Refer to “How to Start Adaptive Server in Single-User Mode”.
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.
Run installmaster or alter master for 2MB if master was originally 5MB.
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 will shut itself 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.
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”.
Load or rebuild the model database if necessary. Refer to “How to Alter the model Database”.
Drop, re-create, and load any user databases located fully or partially on the master device.
WARNING! Storing system databases sybsystemprocs, sybsecurity, and sybsyntax, and user databases on the master device is not recommended, as this greatly complicates disaster recovery.
