disk init

Makes a physical device or file usable by the SAP ASE server.

Syntax

disk init 
	name = "device_name", 
	physname = { 'physical_name' | 'cache_name'} 
	skip_alloc={true | false}, 
	[vdevno = virtual_device_number,]
	size = number_of_blocks 
	[, type = 'inmemory' ]
	[, vstart = virtual_address 
		, cntrltype = controller_number] 
		[, dsync = {true | false}]
	[, directio = {true | false}]
	[, instance = "instance_name"]

Parameters

Examples

Usage

See also sp_diskdefault, sp_dropdevice, sp_helpdevice, sp_logdevice in Reference Manual: Procedures.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

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

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 init permission is not transferable.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

20

Audit option

disk

Command or access audited

disk init

Information in extrainfo
  • Roles – current active roles

  • Keywords or optionsdisk init

  • 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
dump database
dump transaction
disk reinit
create database
alter database
disk refit
load database
load transaction