Question

（写出每个题目对应的T-SQL语句）

Answer 1

1、第一题

create database ReadBook

on

(name=ReadBook_data,

filename='d:sqlserverreadbook.mdf',

size=2,

filegrowth=1,

maxsize = 5

)

log on

(name=ReadBook_log,

filename='d:sqlserverreadbook.ldf',

size=1,

filegrowth=1,

maxsize = 5

)

2、第二题

alter database ReadBook

add filegroup bookgroup

go

alter database ReadBook

add file

( name='book2_dat',

filename='d:sqlserverbook2_dat',

size=5,

maxsize=50,

filegrowth=5)

3、第三题

alter database ReadBook

remove file book2_dat

4、第四题

alter database ReadBook

remove filegroup bookgroup