Properties |
Device Number | 7 |
Physical File Name | /dev/rdsk/c7t6d0s3 |
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 | 1000.00 MB | Space Free | 0.00 MB |
Database Fragments |
Database Name | Size | Database Usage |
browseprod | 1000 | data only |
DDL |
USE master go DISK INIT NAME='browseprod_dev1', PHYSNAME='/dev/rdsk/c7t6d0s3', VDEVNO=7, SIZE=512000, VSTART=0, CNTRLTYPE=0 go EXEC sp_diskdefault 'browseprod_dev1',defaultoff go