DISK RESIZE Statement

Allows you to expand a device. You can use DISK RESIZE on any database device, including the MASTER device.

Syntax

DISK RESIZE
    NAME = logical_device_name,
    SIZE = final_size

where

logical_device_name

Specifies the database device to resize.

final_size

Is the final size to which the device should be expanded, specified in 2K pages.

Remarks

The DISK RESIZE statement expands a device; it does not shrink devices or alter any databases that reside on that device. DISK RESIZE cannot be used for dump devices or the TEMPDB device when tempdb is in RAM.

Permission

DISK RESIZE permission defaults to the system administrator and is not transferable.

Examples

A.    Increase the Size of a Device

This example increases the size of DEVICE1 from it's initial size of 12 MB to 20 MB.

DISK RESIZE 
    NAME = 'DEVICE1', 
    SIZE = 10240

B.    Increase the Size of the MASTER Device

This example increases the MASTER device from its initial size of 25 MB to 32 MB.

DISK RESIZE
    NAME = 'MASTER',
    SIZE = 16384

See Also