更改数据库

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