create database sample //创建数据库
on primary //基本文件组
(
name=sample_data, //数据库逻辑名称
filename='d:\sample_data.mdf', //数据库物理名称
size=5MB, //初始容量5MB
maxsize=50MB, //最大容量50MB
filegrowth=10% //增幅10%
)
//创建
create database business
on primary
(name=businessdat1,
filename='d:\data\businessdat1.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10)
(name=businessdat2,
filename='d:\data\businessdat2.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10)
filegroup business_group
(name=business_dat3,
file='d:\data\businessdat3.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10%)
log on
(name=business_log,
filename='d:\data\businesslog.ldf',
size=8mb,
maxsize=100mb,
filegrowth=10mb)
//添加操作
alter database sales
add filegroup user1
add file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)
add log file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)
to filegroup user1
//删除操作
alter database sales
remove file xxx
alter database sales
remove filegroup user1
//修改数据库
alter database sales
modify file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)
alter database sales
alter database sales
modify name=s_ales
//重命名数据库
sp_renamedb'old_name','new_name'
//删除数据库
drop database sales
on primary //基本文件组
(
name=sample_data, //数据库逻辑名称
filename='d:\sample_data.mdf', //数据库物理名称
size=5MB, //初始容量5MB
maxsize=50MB, //最大容量50MB
filegrowth=10% //增幅10%
)
//创建
create database business
on primary
(name=businessdat1,
filename='d:\data\businessdat1.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10)
(name=businessdat2,
filename='d:\data\businessdat2.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10)
filegroup business_group
(name=business_dat3,
file='d:\data\businessdat3.mdf',
size=10mb,
maxsize=50mb,
filegrowth=10%)
log on
(name=business_log,
filename='d:\data\businesslog.ldf',
size=8mb,
maxsize=100mb,
filegrowth=10mb)
//添加操作
alter database sales
add filegroup user1
add file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)
add log file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)
to filegroup user1
//删除操作
alter database sales
remove file xxx
alter database sales
remove filegroup user1
//修改数据库
alter database sales
modify file
(name=xxx,
filename=xxx,
size=xxx,
maxsize=xxx,
filegrowth=xxx)
alter database sales
alter database sales
modify name=s_ales
//重命名数据库
sp_renamedb'old_name','new_name'
//删除数据库
drop database sales