1、数据库创建
CREATE DATABASE KING
ON
(
NAME=KING,
FILENAME='D:\game setting\SQL Server2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\KING.mdf',
SIZE=5MB,
MAXSIZE=UNLIMITED,
FILEGROWTH=2MB
)
LOG ON
(
NAME=KING_log,
FILENAME='D:\game setting\SQL Server2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\KING_log.ldf',
SIZE=1MB,
MAXSIZE=10MB,
FILEGROWTH=10%
)
2、数据库修改
ALTER DATABASE KING
MODIFY FILE
(
NAME=KING,
SIZE=50MB
)
GO
ALTER DATABASE KING
MODIFY FILE
(
NAME=KING,
FILEGROWTH=5MB
)
GO
3、移除附加文件
ALTER DATABASE KING
REMOVE FILE KING_dat
GO
4、添加文件到文件组
ALTER DATABASE KING
ADD FILEGROUP Test1FG2
GO
ALTER DATABASE KING
ADD FILE
(NAME=KING2,
FILENAME='D:\game setting\SQL Server2012\MSSQL11.MSSQLSERVER\MSSQL\DATA\KING2.ndf',
SIZE=5MB,
MAXSIZE=100MB,
FILEGROWTH=5MB
)
TO FILEGROUP Test1FG2
ALTER DATABASE KING
MODIFY FILEGROUP Test1FG2 DEFAULT
GO
5、查看数据库
sp_helpdb KING
6、删除数据库
DROP DATABASE KING