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.

Step

See

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

“Step 1: Find copies of system tables”

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

“Step 2: Build a new master device”

Restart Adaptive Server in master-recover mode.

“Step 3: Start Adaptive Server in master-recover mode”

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

“Step 4: Re-create device allocations for master”

Update the Backup Server network name in the sysservers table.

“Step 5: Check your Backup Server sysservers information”

Verify that your Backup Server is running.

“Step 6: Verify that your Backup Server is running”

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

“Step 7: Load a backup of master”

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

“Step 8: Update the number of devices configuration parameter”.

Restart Adaptive Server in single-user mode.

“Step 9: Restart Adaptive Server in master-recover mode”

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

“Step 10: Check system tables to verify current backup of master”

Restart Adaptive Server.

“Step 11: Restart Adaptive Server”

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

“Step 12: Restore server user IDs”

Restore the model database.

“Step 13: 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.

“Step 14: Check Adaptive Server”

Dump the master database.

“Step 15: Back up master”