创建数据库 y2
createdatabase y2
onprimary
(name='y2',
filename='E:\y2.mdf',
size=1mb,
maxsize=10mb,
filegrowth=1%)
创建数据库y2 日志文件
logon
(name='y2_log',
filename='E:\y2_log.ldf',
size=1mb,
maxsize=10mb,
filegrowth=2mb)
添加数据库y2 辅助文件
alterdatabase y2
add file
(name='y2_1',
filename='E:\y2_1.ndf',
size=1mb,
maxsize=10mb,
filegrowth=2%)
添加数据库y2 日志文件
alterdatabase y2
add log file
(name='y2_log_2',
filename='E:\y2_log_2.ldf',
size=1mb,
maxsize=10mb,
filegrowth=1%)
对数据库y2 扩容量
alterdatabase y2
modify file
(name='y2',
size=20mb,
maxsize=30mb)
收缩数据库
use[y2]
go
dbcc shrinkdatabase(N'y2',85)
go
收缩文件
USE [y2]
GO
DBCC SHRINKFILE (N'y2',0, TRUNCATEONLY)
GO
分离数据库
USE [master]
GO
EXEC master.dbo.sp_detach_db@dbname = N'y2'
GO
2.分离数据库
use [y2]
GO
use [master]
GO
USE [master]
GO
ALTER DATABASE [y2] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
USE [master]
GO
EXEC master.dbo.sp_detach_db @dbname = N'y2'
GO
附加数据库
create database [y2] on
(filename=N'E:\y2.mdf'),
(filename=N'E:\y2_1.ndf'),
(filename=N'E:\y2_log_2.ldf')
for attach
go
删除辅助库文件
alter database y2
remove file y2_1
删除数据库y2
use master
drop database y2
