Properties

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

Size

Device Size

1000.00 MB

Space Used

999.00 MB

Space Free

1.00 MB

Database Fragments

Database Name	Size	Database Usage
icsa	500	log only
icsa	50	log only
controls	75	log only
controls	50	log only
controls	50	log only
icsa_tmp	110	log only
icsa_tmp	20	log only
browseprod	15	log only
udf	25	log only
publications	1	log only
publications	1	log only
publications	1	log only
publications	1	log only
speval	100	log only

DDL

USE master
go
DISK INIT
    NAME='log_dev1',
    PHYSNAME='/dev/rdsk/c9t4d0s6',
    VDEVNO=11,
    SIZE=512000,
    VSTART=0,
    CNTRLTYPE=0
go
EXEC sp_diskdefault 'log_dev1',defaultoff
go