Restores usage information from the system tables when a device exists (the file is present) but the entries in the sysusages table no longer exist. This occurs after a damaged master database is restored and the master database is incomplete (databases and devices were added or altered since the last backup of the master database).
DISK REFIT
DISK REFIT is executed after DISK REINIT. DISK REFIT uses information in the sysdevices table to rebuild the sysusages and sysdatabases tables. To run DISK REFIT, SQL Server must be started in single-user mode and the system administrator must be using the master database. For information on starting the server in single-user mode, see the Utilities and Executables topic.
After using DISK REFIT, stop and restart SQL Server.
Note If this statement is not immediately run after the DISK INIT statement, DISK INIT will fail. To see the complete recovery steps (DISK REINIT and then DISK REFIT), see the DISK REINIT statement examples.
Execute permission defaults to the system administrator and is not transferable.
| DISK INIT | sp_helpdevice |
| DISK REINIT |