我爱Aspx >> 数据库 >> 更改数据库Extending database by 2.00 mb on disk @#mydb_data5@#.
The filegroup property @#default@# has been set.
例6-9 添加两个事务日志文件到mydb 数据库中去
alter database mydb
add log file
( name = mydb_log4,
filename = @#d:\sql data\mydb_log4.ndf@#,
size = 1mb,
maxsize = 50mb,
filegrowth = 5%),
( name = mydb_log5,
filename = @#d:\sql data\mydb_log5.ndf@#,
size = 1mb,
maxsize = 50mb,
filegrowth = 5%)go
运行结果如下
Extending database by 1.00 MB on disk @#mydb_Log4@#.
Extending database by 1.00 MB on disk @#mydb_Log5@#.
例6-10 修改mydb 数据库中的mydb_Data5 文件增容方式为一次增加2MB
alter database mydb
modify file
( name = mydb_log5,
filegrowth = 2mb)
运行结果如下
The command(s) completed successfully.
例6-11 删除mydb 数据库中的事务日志文件mydb_Log5
alter database mydb
【我对这篇文章有话说?】