Database Options

Enabled Options

select into/bulkcopy/pllsort

Placement

Device Name	Size	Usage
controls_dev	300	data only
controls_dev2	200	data only
controls_dev2	190	data only
data_dev7	300	data only
log_dev1	75	log only
log_dev2	25	log only
log_dev1	50	log only
log_dev1	50	log only

Database Usage

Data	349.19 (35.27 %)
Indexes	232.68 (23.50 %)
Unused	9.21 (0.93 %)
Unreserved	398.92 (40.30 %)

Log Usage

Log Used	117.46 (58.73 %)
Log Unused	82.54 (41.27 %)

DDL

USE master
go
CREATE DATABASE controls
    ON controls_dev=300
    LOG ON log_dev1=75,       
    log_dev2=25
go
ALTER DATABASE controls 
    ON controls_dev2=200
go
ALTER DATABASE controls 
    ON controls_dev2=190
go
ALTER DATABASE controls 
    LOG ON log_dev1=50
go
ALTER DATABASE controls 
    ON data_dev7=300
go
ALTER DATABASE controls 
    LOG ON log_dev1=50
go
USE master
go
EXEC sp_dboption 'controls','select into/bulkcopy/pllsort',true
go
USE controls
go
CHECKPOINT
go
USE controls
go
EXEC sp_changedbowner 'isopma'
go
EXEC sp_addsegment 'default','controls','controls_dev'
go
EXEC sp_extendsegment 'default','controls','controls_dev2'
go
EXEC sp_extendsegment 'default','controls','data_dev7'
go
EXEC sp_addthreshold 'controls','default',25600,'sp_freespacethreshold'
go
EXEC sp_addsegment 'logsegment','controls','log_dev1'
go
EXEC sp_extendsegment 'logsegment','controls','log_dev2'
go
EXEC sp_addthreshold 'controls','logsegment',6040,'sp_lastchancethreshold'
go
EXEC sp_addthreshold 'controls','logsegment',25600,'sp_freespacethreshold'
go
EXEC sp_addsegment 'system','controls','controls_dev'
go
EXEC sp_extendsegment 'system','controls','controls_dev2'
go
EXEC sp_extendsegment 'system','controls','data_dev7'
go