Summary of recovery procedure

You must follow the steps below to restore a damaged master device. Each step is discussed in more detail on the following pages.

  1. Find hard copies of the system tables needed to restore disks, databases and logins.

  2. Shut down Adaptive Server, and use dataserver to build a new master database and master device.

  3. Restart Adaptive Server in master-recover mode.

  4. Re-create the master database’s allocations in sysusages exactly.

  5. Update the Backup Server network name in the sysservers table.

  6. Verify that your Backup Server is running.

  7. Use load database to load the most recent database dump of master. Adaptive Server stops automatically after successfully loading master.

  8. Update the number of devices configuration parameter in the configuration file.

  9. Restart Adaptive Server in single-user mode.

  10. Verify that the backup of master has the latest system tables information.

  11. Restart Adaptive Server.

  12. Check syslogins if you have added new logins since the last backup of master.

  13. Restore the model database.

  14. 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.

  15. Dump the master database.