1.

create database 商品資訊資料庫

on primary

(name=‘商品資訊資料庫",FILENAME="d:\商品資訊資料庫.mdf",size=10mb,maxsize=50mb,filegrowth=2mb)

log on

(name=‘商品資訊日誌",FILENAME="d:\商品資訊日誌.ldf",size=5mb,maxsize=25mb,filegrowth=1mb)

2.

create database Sales

on primary

(name=‘Sales_Data",FILENAME="d:\Sales_Data.mdf",size=20mb,maxsize=50mb,filegrowth=5%)

Filegroup fg1(name=‘Sales_Data2",FILENAME="d:\Sales_Data2.ndf",size=20mb,maxsize=50mb,filegrowth=5%)

log on

(name=‘Sales_log",FILENAME="d:\Sales_log.ldf",size=10mb,maxsize=50mb,filegrowth=5mb)

3.

drop database 商品資訊資料庫

drop database sales