If you have backed up the master database since issuing the most recent disk init, create database, or alter database command, then the contents of sysusages, sysdatabases, and sysdevices will match your hard copy.
Check the sysusages, sysdatabases, and sysdevices tables in your recovered server against your hard copy. Look especially for these problems:
If any devices in your hard copy are not included in the restored sysdevices, then you have added devices since your last backup, and you must run disk reinit and disk refit. For information on using these commands, see “Restoring system tables with disk reinit and disk refit”.
If any databases listed in your hard copy are not listed in your restored sysdatabases table, you have added a database since the last time you backed up master. You must run disk refit (see “Restoring system tables with disk reinit and disk refit”).
You must start Adaptive Server with trace flag 3608
before you run disk refit. However, make sure
you read the information provided in the Troubleshooting
and Error Messages Guide before you start Adaptive Server
with any trace flag.
