Database Options

Enabled Options

Placement

Device Name	Size	Usage
speval_dev	2000	data only
data_dev5	390	data only
log_dev1	100	log only

Database Usage

Data	1502.32 (62.86 %)
Indexes	804.63 (33.67 %)
Unused	5.68 (0.24 %)
Unreserved	77.37 (3.24 %)

Log Usage

Log Used	0.11 (0.11 %)
Log Unused	99.89 (99.89 %)

DDL

USE master
go
CREATE DATABASE speval
    ON speval_dev=2000
    LOG ON log_dev1=100
go
ALTER DATABASE speval 
    ON data_dev5=390
go
USE speval
go
EXEC sp_changedbowner 'isopma'
go
EXEC sp_addsegment 'default','speval','data_dev5'
go
EXEC sp_extendsegment 'default','speval','speval_dev'
go
EXEC sp_addsegment 'logsegment','speval','log_dev1'
go
EXEC sp_addthreshold 'speval','logsegment',3024,'sp_thresholdaction'
go
EXEC sp_addsegment 'system','speval','data_dev5'
go
EXEC sp_extendsegment 'system','speval','speval_dev'
go