disk reinit

Rebuilds the master database’s sysdevices system table. Use disk reinit as part of the procedure to restore the master database.

Syntax

disk reinit 
	name = "device_name", 
	physname = "physicalname" , 
	[vdevno = virtual_device_number ,]
	size = number_of_blocks 
	[, vstart = virtual_address 
		, cntrltype = controller_number]
		[, dsync = {true | false}]
	[, directio = {true | false}]
	[, instance = "instance_name"]

Parameters

Examples

Usage

See also sp_addumpdevice, sp_helpdevice in Reference Manual: Procedures.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for disk reinit differ based on your granular permissions settings. You must be using the master database to use disk reinit.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage disk privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.

disk reinit permission is not transferable.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

22

Audit option

disk

Command or access audited

disk reinit

Information in extrainfo
  • Roles – current active roles

  • Keywords or optionsdisk reinit

  • Previous value – NULL

  • Current value – NULL

  • Other information – name of the disk

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

Related reference
disk init
alter database
create database
dbcc
disk refit