Object Type	Database Device
Datasource	IPMA
Database	N/A

Properties

Device Number 13

Physical File Name /sybdata/IPMA_1/log_dev2.dat

Is Default Device No

Is Physical Disk Yes

Is Logical Disk No

Is Mirrored No

Physical Mirror Name

Size

Device Size 25.00 MB Space Used 25.00 MB Space Free 0.00 MB

Database Fragments

Database Name Size Database Usage

controls 25 log only

DDL

USE master
go
DISK INIT
    NAME='log_dev2',
    PHYSNAME='/sybdata/IPMA_1/log_dev2.dat',
    VDEVNO=13,
    SIZE=12800,
    VSTART=0,
    CNTRLTYPE=0
go
EXEC sp_diskdefault 'log_dev2',defaultoff
go

Device Number	13
Physical File Name	/sybdata/IPMA_1/log_dev2.dat
Is Default Device	No
Is Physical Disk	Yes
Is Logical Disk	No
Is Mirrored	No
Physical Mirror Name

Database Name	Size	Database Usage
controls	25	log only