disk refit

Description

Rebuilds the master database’s sysusages and sysdatabases system tables from information contained in sysdevices.

Syntax

disk refit

Usage

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

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

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.

Auditing

Values in event and extrainfo columns of sysaudits are:

Event

Audit option

Command or access audited

Information in extrainfo

21

disk

disk refit

  • Roles – current active roles

  • Keywords or optionsdisk refit

  • Previous value – NULL

  • Current value – NULL

  • Other information – Name of the disk

  • Proxy information – original login name, if set proxy is in effect

See also

Documents System Administration Guide.

Commands disk init, disk reinit

System procedures sp_addumpdevice, sp_helpdevice