To restore a damaged master device, follow the recovery steps below, or use the
sybrestore utility.
You have the option to use the sybrestore utility to restore an SAP
ASE master database in the event of a master database corruption. See Master Database
Restore in the Utility Guide.
- Find hard copies of the system tables needed to restore disks, databases and
logins.
- Shut down SAP ASE, and use dataserver to build a new
master database and master device.
- Restart SAP ASE in master-recover mode.
- Re-create the master database’s allocations in
sysusages exactly.
- Update the Backup Server network name in the sysservers table.
- Verify that your Backup Server is running.
- Use load database to load the most recent database dump of
master. SAP ASE stops automatically after successfully loading
master.
- Update the number of devices configuration parameter in the
configuration file.
- Restart SAP ASE in single-user mode.
- Verify that the backup of master has the latest system tables
information.
- Restart SAP ASE.
- Check syslogins if you have added new logins since the last backup
of master.
- Restore the model database.
- Compare hard copies of sysusages and sysdatabases
with the new online version, run dbcc checkalloc on each database,
and examine the important tables in each database.
- Dump the master database.