Properties

Device Number	18
Physical File Name	/dev/rdsk/c2t0d0s4
Is Default Device	No
Is Physical Disk	Yes
Is Logical Disk	No
Is Mirrored	No
Physical Mirror Name

Size

Device Size

400.00 MB

Space Used

390.00 MB

Space Free

10.00 MB

Database Fragments

Database Name	Size	Database Usage
controls	200	data only
controls	190	data only

DDL

USE master
go
DISK INIT
    NAME='controls_dev2',
    PHYSNAME='/dev/rdsk/c2t0d0s4',
    VDEVNO=18,
    SIZE=204800,
    VSTART=0,
    CNTRLTYPE=0
go
EXEC sp_diskdefault 'controls_dev2',defaultoff
go