Properties

Device Number	12
Physical File Name	/sybdata/IPMA_3/tempdv_dev.dat
Is Default Device	No
Is Physical Disk	Yes
Is Logical Disk	No
Is Mirrored	No
Physical Mirror Name

Size

Device Size

500.00 MB

Space Used

500.00 MB

Space Free

0.00 MB

Database Fragments

Database Name	Size	Database Usage
tempdb	500	data and log

DDL

USE master
go
DISK INIT
    NAME='tempdb_dev',
    PHYSNAME='/sybdata/IPMA_3/tempdv_dev.dat',
    VDEVNO=12,
    SIZE=256000,
    VSTART=0,
    CNTRLTYPE=0
go
EXEC sp_diskdefault 'tempdb_dev',defaultoff
go