sql server学习记录

---------------------------------------------------------------------------------------- create database forum on primary( name = forum_data, filename = 'd:\forum.mdf', size = 3MB, maxsize = 50MB, filegrowth = 2MB ) log on( name = forum_log, filename = 'd:\forum.ldf', size = 2MB, maxsize = 100MB, filegrowth = 10% ) Alter database forum modify file( name = forum_data, newname = forum1_data ) Alter database forum modify file( name = forum_log, newname = forum1_log ) Alter database forum modify file( name = forum1_data, size = 10MB, ) Alter database forum modify file( name = forum1_log, size = 8MB ) use forum dbcc shrinkfile ('forum1_data',5) use forum dbcc shrinkfile ('forum1_log',4) Alter database forum add file( name = forum2_data, filename = 'd:\forum2.ndf', size = 5MB, maxsize = 100MB, filegrowth = 2MB ) Alter database forum add log file( name = forum2_log, filename ='d:\forum2.log', size = 2MB, maxsize = 200MB, filegrowth = 5MB ) Alter database forum remove file forum2_data Alter database forum remove file forum2_log drop database forum------- ------->此处由于数据库正在使用，无法删除 可以试试 use master drop database forum go