sql server 作业题

------------------------------------------------------------------------------------

create database sqltest1

on primary(

name = sqltest_m_data,

filename = 'd:\test1\sqltest_m_data.mdf',

size = 10MB,

maxsize = 50MB,

filegrowth = 10%

)

,filegroup fielgroup_1(

name = sqltest_n_data,

filename = 'd:\test1\sqltest_n_data.ndf'

)

log on(

name = sqltest_l_log,

filename = 'd:\test1\sqltest_l_log.ldf',

size = 5MB,

maxsize = 50MB,

filegrowth = 1MB

)

exec sp_helpdb sqltest1

Alter database sqltest1

modify file(

name = sqltest_m_data,

size = 10MB,

filegrowth = 5%

)

Alter database sqltest1

remove file

sqltest_n_data

Alter database sqltest1

add filegroup

filegroup_2

Alter database sqltest1

add file(

name = sqltest1_n_data2,

filename = 'd:\test1\sqltest1_n_data2.ndf'

)

to filegroup filegroup_2

Alter database sqltest1

modify filegroup-------------------------此处是易错点

filegroup_2

name = filegroup3