创建数据库 y2
create database y2 on primary (name='y2', filename='E:\y2.mdf', size=1mb, maxsize=10mb, filegrowth=1%)
创建数据库y2 日志文件
log on (name='y2_log', filename='E:\y2_log.ldf', size=1mb, maxsize=10mb, filegrowth=2mb)
添加数据库y2 辅助文件
alter database y2 add file (name='y2_1', filename='E:\y2_1.ndf', size=1mb, maxsize=10mb, filegrowth=2%)
添加数据库y2 日志文件
alter database y2 add log file (name='y2_log_2', filename='E:\y2_log_2.ldf', size=1mb, maxsize=10mb, filegrowth=1%)
对数据库y2 扩容量
alter database y2 modify file (name='y2', size=20mb, maxsize=30mb)
收缩数据库
use[y2] go use[y2] go dbcc shrinkdatabase(N'y2',85) go
收缩文件
USE [y2] GO DBCC SHRINKFILE (N'y2' , 0, TRUNCATEONLY) GO
1分离数据库
USE [master] GO EXEC master.dbo.sp_detach_db @dbname = N'y2' GO
2.分离数据库
use [y2]
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
