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

disk refit permission defaults to system administrators and is not transferable. You must be in the master database to use disk refit.

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