Rebuilds the master database’s sysusages and sysdatabases system tables from information contained in sysdevices.
disk refit
Adaptive Server automatically shuts down after disk refit rebuilds the system tables.
Use disk refit after disk reinit as part of the procedure to restore the master database.
You must start Adaptive Server with trace flag 3608 before you run disk refit. However, make sure you read the information in the Troubleshooting and Error Messages Guide before you start Adaptive Server with any trace flag.
ANSI SQL – Compliance level: Transact-SQL extension.
The permission checks for disk refit differ based on your granular permissions settings. You must be using the master database to use disk refit.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage disk privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. disk refit permission is not transferable. |
Values in event and extrainfo columns of sysaudits are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
---|---|---|---|
21 |
disk |
disk refit |
|
Documents System Administration Guide.
Commands disk init, disk reinit
System procedures sp_addumpdevice, sp_helpdevice