創(chuàng)建數(shù)據(jù)庫 y2
??? createdatabase y2
??? onprimary
??? (name='y2',
??? filename='E:\y2.mdf',
?? size=1mb,
?? maxsize=10mb,
?? filegrowth=1%)
創(chuàng)建數(shù)據(jù)庫y2 日志文件
?? logon
? (name='y2_log',
? filename='E:\y2_log.ldf',
? size=1mb,
? maxsize=10mb,
? filegrowth=2mb)
添加數(shù)據(jù)庫y2 輔助文件
? alterdatabase y2
? add? file
? (name='y2_1',
? filename='E:\y2_1.ndf',
? size=1mb,
?? maxsize=10mb,
?? filegrowth=2%)
添加數(shù)據(jù)庫y2 日志文件
?? alterdatabase y2
?? add log file
? (name='y2_log_2',
?? filename='E:\y2_log_2.ldf',
?? size=1mb,
?? maxsize=10mb,
?? filegrowth=1%)
對數(shù)據(jù)庫y2 擴(kuò)容量
?? alterdatabase y2
? modify? file
? (name='y2',
? size=20mb,
? maxsize=30mb)
收縮數(shù)據(jù)庫
??? use[y2]
??? go
?? dbcc shrinkdatabase(N'y2',85)
?? go
收縮文件
? USE [y2]
? GO
? DBCC SHRINKFILE (N'y2',0, TRUNCATEONLY)
? GO
分離數(shù)據(jù)庫
? ? USE [master]
? ? GO
??? EXEC master.dbo.sp_detach_db@dbname = N'y2'
?? GO
2.分離數(shù)據(jù)庫
??? 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
附加數(shù)據(jù)庫
? 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
刪除數(shù)據(jù)庫y2
? use master
? drop database y2
