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