Database Options

Enabled Options

select into/bulkcopy/pllsort

trunc log on chkpt

Placement

Device Name	Size	Usage
data_dev5	100	data only
log_dev1	25	log only

Database Usage

Data	4.76 (4.76 %)
Indexes	0.11 (0.11 %)
Unused	1.25 (1.25 %)
Unreserved	93.88 (93.88 %)

Log Usage

Log Used	0.02 (0.06 %)
Log Unused	24.98 (99.94 %)

DDL

USE master
go
CREATE DATABASE udf
    ON data_dev5=100
    LOG ON log_dev1=25
go
USE master
go
EXEC sp_dboption 'udf','select into/bulkcopy/pllsort',true
go
EXEC sp_dboption 'udf','trunc log on chkpt',true
go
USE udf
go
CHECKPOINT
go
USE udf
go
EXEC sp_changedbowner 'isopma'
go
EXEC sp_addsegment 'default','udf','data_dev5'
go
EXEC sp_addsegment 'logsegment','udf','log_dev1'
go
EXEC sp_addthreshold 'udf','logsegment',768,'sp_thresholdaction'
go
EXEC sp_addsegment 'system','udf','data_dev5'
go