复制USE[master]   ALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2001]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2002]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2003]   GOALTERDATABASE[AdventureWorksDW]ADDFILEGROUP [fg2004]   GOALTERDATABASE[AdventureWorksDW]ADDFILE   (NAME =NAdventureWorksDW_Data2001,数数据   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/>SQL10.MSServerSecurity/Database/> SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2001.ndf,   SIZE =2048KB , FILEGROWTH =1024KB ) TOFILEGROUP [fg2001]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILE(NAME =NAdventureWorksDW_Data2002,   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/> SQL10.MSServerSecurity/Database/>SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2002.ndf,   SIZE =2048KB , FILEGROWTH =1024KB ) TOFILEGROUP [fg2002]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILE(NAME =NAdventureWorksDW_Data2003,   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/> SQL10.MSServerSecurity/Database/>SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2003.ndf,   SIZE =2048KB , FILEGROWTH =1024KB) TOFILEGROUP [fg2003]   GO   ALTERDATABASE[AdventureWorksDW]ADDFILE   (NAME =NAdventureWorksDW_Data2004,   FILENAME =NC:Program FilesMicrosoft ServerSecurity/Database/>SQLServerMSServerSecurity/Database/> SQL10.MSServerSecurity/Database/>SQLSERVERMSServerSecurity/Database/>SQLDATAAdventureWorksDW_Data2004.ndf,   SIZE =2048KB , FILEGROWTH =1024KB ) TOFILEGROUP [fg2004]   GO  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.

(责任编辑：IT科技)