Database Options

Enabled Options

Placement

Device Name	Size	Usage
browseprod_dev1	1000	data only
browseprod_dev2	1000	data only
log_dev1	15	log only

Database Usage

Data	13.07 (0.65 %)
Indexes	1392.78 (69.64 %)
Unused	7.92 (0.40 %)
Unreserved	586.24 (29.31 %)

Log Usage

Log Used	0.11 (0.73 %)
Log Unused	14.89 (99.27 %)

DDL

USE master
go
CREATE DATABASE browseprod
    ON browseprod_dev1=1000,   
    browseprod_dev2=1000
    LOG ON log_dev1=15
go
USE browseprod
go
EXEC sp_changedbowner 'isopma'
go
EXEC sp_addsegment 'default','browseprod','browseprod_dev1'
go
EXEC sp_extendsegment 'default','browseprod','browseprod_dev2'
go
EXEC sp_addsegment 'logsegment','browseprod','log_dev1'
go
EXEC sp_addthreshold 'browseprod','logsegment',464,'sp_thresholdaction'
go
EXEC sp_addsegment 'system','browseprod','browseprod_dev1'
go
EXEC sp_extendsegment 'system','browseprod','browseprod_dev2'
go